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

206 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
whin10522569(None) 
chin96934741chin
hin67559561_hin
shin75634311shin
thin76732391thin
wain75840201wain
when105723041when
whid115418871whid
whig115516421whig
whim126220531whim
whine116022811whine
whins114922331whins
whiny144915571whiny
whip125521841whip
whir105519281whir
whit104834171whit
whiz195919941whiz
win66456291w_in
agin56132712agin
ahi68040232ahi_
ahing98928352ahing
ahis76135382ahis
ain37579092_ain
akin86328032akin
amin66042252amin
ayin76331742ayin
bin56658642_bin
blin67228172blin
brin67038192brin
cain65643912cain
chain105723672chain
chi86228652chi_
chia96026622chia
chic115925202chic
chid106626402chid
china105022482china
chine105231722chine
chink145321592chink
chino105823312chino
chins105631462chins
chip116726422chip
chis95933312chis
chit96937462chit
chon96627792chon
coin66645352coin
din46459462_din
djin12911632djin
fain75840562fain
fin66458032_fin
foin77231562foin
gain56042162gain
ghi77019882ghi_
ghis85020162ghis
gin46055752_gin
grin55733722grin
hen67555272_hen
hi57947582_hi_
hic86540562_hic
hid76248382_hid
hie67652702_hie
him86247662_him
hind85529752_hind
hins76447992_hins
hint77455742_hint
hip86750432_hip
his66359502_his
hisn79620932_hisn
hit66569192_hit
hon67759382_hon
hun65844712_hun
hwan105716892hwan
in28150862__in
jin106443932_jin
join116724832join
kain85334292kain
khan115819142khan
khi106318302khi_
khis117017982khis
kin76353972_kin
lain46146282lain
lin37967372_lin
loin46838722loin
main65345522main
ohia75719362ohia
ohing96018812ohing
pain65647242pain
pein65834942pein
phi86524202phi_
phis95724902phis
phiz186718842phiz
phon95925382phon
pin57066722_pin
pyin96823232pyin
quin135823922quin
rain46251732rain
rein46040892rein
rhino84614322rhino
rin36663182_rin
ruin47430512ruin
sain45551292sain
shim95827862shim
shine85533092shine
shins85131042shins
shiny115122142shiny
ship95228242ship
shit76745942shit
shiv105721172shiv
shun75122772shun
sin36265892_sin
skin85927532skin
spin66231302spin
swain84919052swain
tain45548072tain
than76128772than
thein85919022thein
then78429692then
thine85026862thine
thing96622982thing
think125018802think
thins85826332thins
thio77225412thio
thir76420542thir
this76027382this
tin36362172_tin
twain86313622twain
twin76023082twin
tyin76424002tyin
vain75233002vain
vein75625752vein
wahine123813012wahine
waif105836752waif
wail75238822wail
wains86930872wains
wair75830052wair
wait75553692wait
wan66761942w_an
warn75239322warn
wean75734352wean
ween75835462ween
weir76019922weir
wen66249602w_en
wha96422072wh_a
wham125321692wham
whang124813382whang
whap125119642whap
what105434072what
whee105429592whee
wheen115016052wheen
whens114618762whens
whet105133782whet
whew137618782whew
whey135018712whey
which163910082which
whids125413982whids
whiff17310062whiff
whigs125612642whigs
while115418692while
whims134515332whims
whined134715202whined
whiner124516632whiner
whines125120102whines
whiney155012642whiney
whinge134311542whinge
whinny15587492whinny
whips134917082whips
whipt135317422whipt
whirl114913822whirl
whirr114611192whirr
whirs115218092whirs
whish144512922whish
whisk154510142whisk
whist115322952whist
white114920302white
whiten124111922whiten
whits115923822whits
whity145513472whity
whizz194210322whizz
who95526772wh_o
whoa106615202whoa
whom127018182whom
whop125520922whop
whup125714162whup
why126920012wh_y
whys137011662whys
wig76740382w_ig
wind85533852w_ind
wine74953422w_ine
wing86339222w_ing
wink116435022w_ink
wino75933612w_ino
wins75949172w_ins
winy107034322w_iny
wis66552332w_is
wit66563772w_it
within123611382within
wiz156434152w_iz
won66252062w_on
worn75631752worn
wren78221682wren
wring95920712wring
writ75537912writ
wyn95921442w_yn
wynn105811292wynn
yin67648732_yin
zein135620602zein
zin125643772_zin

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 Filter178691298720.280638182.1
2DLD Change Limit298722060.79637527.6
3Display Results2062060.0464478.3
 (SQL Overall)1786912061.122159261.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.