Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “felafel” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

120 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
felafel133372(None) 
falafel1383901falafel
felafels1452851felafels
falafels1453112falafels
relabel938162relabel
belaced124112153belaced
belated103520013belated
belayed133610083belayed
belayer12339503belayer
deafen10389673de_afen
deafer104114813de_afer
delate73827753delate_
delated93722873delated
delates83526283delates
delayed123310763delayed
delayer113010533delayer
easel54521113_e_asel
elate55335883_elate_
elated74725823_elated
elater64724203_elater
elates65032363_elates
enamel81210113_enamel
farfel124310433f_arfel
feal713940423fe_a__l
feared106320433fe_ared
fearer94820183fe_arer
fearful1345593fearful
fease84824873fe_ase_
feased105718713fe_ased
feases95422923fe_ases
feater95224053fe_ater
feaze175216313fe_aze_
feazed195112633fe_azed
feazes184514173fe_azes
fecal105119213feca__l
fedayee1445513fedayee
feel75233843fe___el
feline94820143feline_
felinely1445943felinely
felines104718073felines
fell76833073fel___l
fellable13179133fellable
fellate10313433fellate_
fellated1239563fellated
fellates11312753fellates
felled103720303fel_led
feller94419553fel_ler
fellies104119743fellies
felloe93513923felloe_
felloes104114383felloes
felted103714653fel_ted
female11310553female_
females12310663females
fenagle11197153fenagle
fennel9429473fe_nnel
feoffed1332813feoffed
feoffee1243903feoffee
feoffer1233023feoffer
feral85424653fera__l
ferrel92810203fe_rrel
fetal85623373feta__l
filaree10611193filaree
flail85316183f_la_il
flake125119973f_lake_
flaked144715653f_laked
flaker134916173f_laker
flakes134118873f_lakes
flakey164410513f_lakey
flame105124443f_lame_
flamed124618973f_lamed
flamen115215993f_lamen
flamer114919123f_lamer
flames114723693f_lames
flanes94522423f_lanes
flannel1035423f_lannel
flare84823633f_lare_
flared105317603f_lared
flares94521703f_lares
flawed134712723f_lawed
flaxen16518573f_laxen
flaxes165015353f_laxes
flayed134414053f_layed
flayer124713563f_layer
floatel10308013floatel
folate93320393folate_
folates103218453folates
fulfil1246423ful_fil
gelable101710733gelable
gelate73421253gelate_
gelated93615633gelated
gelates83219583gelates
helpful1543963helpful
label75019383__label
lapel73716683__lapel
leafed105713873le_afed
melamed1249633melamed
pelage9515363pelage_
pelages10714613pelages
refel84920813re__fel
relabels1045343relabels
relace83122153relace_
relaced103517213relaced
relaces93420883relaces
relate64033633relate_
related83327573related
relater73723143relater
relates73731433relates
relaxed153312523relaxed
relaxer143410223relaxer
relaxes143215323relaxes
relayed113212753relayed
repanel939963repanel
selfed10310913sel_fed
teasel63914983te_asel
teazel15368543te_azel
telae54323293tela_e_
telfer9379893tel_fer
velamen1237123velamen
velate93720143velate_
weasel93410523we_asel

Search took 10 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.1561145455.1
2DLD Change Limit1340271209.03314837.5
3Display Results1201200.0462608.7
 (SQL Overall)1786911209.23519349.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.