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 “upwinds” 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.

147 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
upwinds1322422(None) 
unwinds11286731unwinds
upbinds12234811upbinds
upwind12255821upwind_
enwinds11255552enwinds
inwinds11216272inwinds
outwinds1235362outwinds
poinds93511142_poinds
rewinds114810482rewinds
unbinds10267352unbinds
unwind102610542unwind_
upbind11246312upbind_
upends9438762up_ends
upgirds11103072upgirds
uplands1036942uplands
uplinks13345612uplinks
uppings12257122uppings
upsends10265292upsends
upswings1433002upswings
upwards13135962upwards
winds95425602__winds
aphids125110843aphi_ds
appends1236393appends
behinds1335283behinds
binds86627473__binds
blinds95111613_blinds
bowings133612003bowings
cowbinds1634453cowbinds
cupids11369193cup_i_ds
cuppings15336053cuppings
dwines105013103_dwines
enwind10298083enwind_
finds95424823__finds
grinds84511843_grinds
hinds96721473__hinds
inwind10268413inwind_
kinds106221823__kinds
lapwings14274973lapwings
lawines103313563lawines
lawings113611473lawings
lowings113710073lowings
lupines93912503lup_ines
lupins84514463lup_in_s
minds85427123__minds
mowings13328483mowings
opines84820703op_ines
opsins8411713opsin_s
outfinds1235643outfinds
outwind1139153outwind_
pains75138283_pain_s
paints85921833_paints
peins76128063_pein_s
pends85527193_p_ends
pinas75434453_p_inas
pines76048863_p_ines
pings85830883_p_ings
pinks115729383_p_inks
pins65558453_p_in_s
pints75936223_p_ints
plinks124913263_plinks
poind84217913_poind_
points85618533_points
ponds85323403_p_onds
pounds93714383_pounds
prinks124315383_prinks
prints84320103_prints
pulings103511323pulings
purines94420763purines
purins83722653purin_s
pyins105815863_pyin_s
rawins95617623rawin_s
rebinds104511873rebinds
refinds114512123refinds
reminds104614793reminds
rewind104715883rewind_
rewins95020823rewin_s
rinds64826143__rinds
rowings113710363rowings
sewings11369173sewings
spends94714473sp_ends
spines85132033sp_ines
spins75327983sp_in_s
splines94718893splines
splints94511743splints
springs104415923springs
sprints94113773sprints
supines94216383sup_ines
swings104714453_swings
swinks134610653_swinks
teinds738263_teinds
twines94717273_twines
twins85118983_twin_s
unbends10236993unbends
unbind93011433unbind_
uncinus937403uncinus
undines8716083undines
ungirds9105303ungirds
unhands1137773unhands
unkind113310573unkind_
unkinks10265413unkinks
unlinks11307403unlinks
unpins82312383unpin_s
untwines1137603untwines
unwinder1235613unwinder
unwinders1343943unwinders
unwits9389893unwi_ts
upbuilds1341753upbuilds
updives1334713updives
upend85011043up_end_
upflings1433733upflings
upfolds13133753upfolds
upgird10103933upgird_
uphills1295233uphills
upholds13135243upholds
upland938863upland_
uplifts12424773uplifts
uplink12388713uplin_k
uploads10266503uploads
uppiles11208263uppiles
upping114013703uppin_g
uprises92012733uprises
upsend9356883upsend_
upside9289803upsi_de
upsides10319633upsides
upsizes18297163upsizes
upstands1144093upstands
upswing1335593upswin_g
upticks1535153upticks
uptilts934733uptilts
uptimes1177553uptimes
uptrends1142833uptrends
upwafts1541943upwafts
upward12147163upward_
upwells12244303upwells
urines64724123u_rines
ursids737823ursi_ds
wands96425483__wands
wends95822813__wends
wilds94818203__wilds
wind85533853__wind_
windy126118103__windy
wines85546863__wines
wings95727243__wings
winks125325433__winks
winos84625043__winos
wins75949173__win_s
wynds126310373__wynds

Search took 9 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.423422437.4
2DLD Change Limit1340271477.89316980.5
3Display Results1471470.0433418.6
 (SQL Overall)1786911478.35921377.1
 
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.