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 “halid” with Change Limit: [1] [2]

(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
halid9442497(None) 
haled95335821haled
halide103417991halide
halids104016131halids
haloid104317751haloid
valid94618381valid
aalii5316122aalii
acid77533392_acid
aid49269072_a_id
alcid85817962_alcid
algid75415572_algid
alif76242132_alif
alit46155692_alit
amid77036332_amid
arid57642712_arid
avid88325962_avid
bald76432902bal_d
baled85436442baled
caid77837532ca_id
calif104929092calif
calix145317342calix
canid85526342canid
chalcid1537872chalcid
felid94717172felid
gadid85517372gadid
gelid74916972gelid
habit103027012habit
had77658762ha__d
haded105227622haded
haed86338582ha_ed
hafiz20611212hafiz
haik115526982ha_ik
hail74839062ha_il
hailed104122742hailed
hails85231642hails
hair76330142ha_ir
haji148520182haji_
hajis156716272hajis
hakim14311822hakim
halal85623592halal
hale76052832hal_e
haler85033522haler
hales85449842hales
half106238452hal_f
halides113416662halides
halidom1386442halidom
haling104229782haling
halite93624232halite
hall75741162hal_l
hallo85127552hallo
halls85633782halls
halm95834972hal_m
halma108219252halma
halms105225212halms
halo76437322hal_o
haloed104717592haloed
haloids113012542haloids
halon86124862halon
halos85230252halos
halt76056302hal_t
halted105019602halted
halts85230102halts
halva115414432halva
halve114818922halve
halved134813902halved
hand86833702ha_nd
haploid1339822haploid
hard85443502ha_rd
hared95742182hared
hated95734022hated
hauled104415212hauled
hawed126025422hawed
hayed125822012hayed
hazed185222202hazed
healed105121442healed
held85330402hel_d
helio85321192helio
helix154413012helix
hid76248362h__id
hili75626632hili_
hold86235062hol_d
holed95634132holed
humid114213762humid
hyalin122210032hyalin
hyaloid1439062hyaloid
hyoid12612422hyoid
kalif125021352kalif
khalif1657832khalif
laid56439142la_id
lid47453512__lid
maid75537632ma_id
malic94525652malic
naled65525052naled
ozalid1696672ozalid
paid75737482pa_id
paled85538722paled
pallid93915272pallid
pavid115717002pavid
plaid85118302plaid
qaid146023842qa_id
rabid84520772rabid
raid55243072ra_id
ranid66429332ranid
rapid86422032rapid
said55742112sa_id
salad65321832salad
salic73424712salic
salpid9510872salpid
sapid84720932sapid
sayid95516722sayid
shaled105023952shaled
sialid7314932sialid
slid55828982_slid
solid65025072solid
tabid84418252tabid
tali46837162tali_
vapid115614282vapid
waled94330992waled
whaled134612032whaled
yald86920602yal_d

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001201.70331591.3
3Display Results1201200.0304000.0
 (SQL Overall)1786911201.82697859.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.