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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
dairy9701630(None) 
airy75734151_airy
daily95922331daily
daisy95915311daisy
diary95016971diary
fairy115318281fairy
hairy115316831hairy
aery77231682_aery
air38058392_air_
airn46433832_airn
airs46447422_airs
airt45757782_airt
awry107619682_awry
bairn77515532bairn
caird85717232caird
cairn75717512cairn
cairny11557822cairny
carry105823782carry
daddy116212562daddy
daffy155510282daffy
daimyo1233192daimyo
dainty105311472dainty
dais57040702dai_s
dally95324742dally
dandy104416702dandy
darb76033532da_rb
dare55848862da_re
daric85623122daric
dark95133212da_rk
darky136018832darky
darn56434622da_rn
dart55857872da_rt
dashy125612382dashy
datary10310242datary
daubry12445482daubry
dauby115211222dauby
davy116015522da_vy
day76254112da__y
deair65817192deair_
deairs74013782deairs
deary95826842deary
decry115514352decry
deify124112762deify
deity94316772deity
derry94721372derry
didy99121512d_idy
dire56644142d_ire
dirk96326832d_irk
dirl57430022d_irl
dirt55550382d_irt
dirty95617802d_irty
doily95321032doily
dory85836232d_ory
dowry126312482dowry
drily95816522drily
dry76526032d__ry
faery116015482faery
fair76332522fair_
fairly125610012fairly
fairs85825442fairs
gaily95020972gaily
glairy10448272glairy
hair76330142hair_
hairs86225172hairs
harry115322952harry
kaury12429762kaury
lair45934152lair_
laird65417792laird
lairs55425872lairs
laity85318902laity
mair66133782mair_
mairs76228302mairs
marry104821692marry
miry96326752_miry
naira5314742naira
nairu5413812nairu
nary76931222na_ry
pair66031512pair_
pairs75325832pairs
parry105323752parry
rainy85921082rainy
saury84317222saury
spiry105017352spiry
tarry85422512tarry
vair75624142vair_
vairs85019132vairs
vary105226062va_ry
wair75830052wair_
wairs86424062wairs
wary106740012wa_ry
wiry106422832_wiry
yaird96111912yaird
zaire14311992zaire

Search took 3 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.343520965.0
2DLD Change Limit53800931.80029888.9
3Display Results93930.0303100.0
 (SQL Overall)178691932.17382232.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.