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

316 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
wain7584020(None) 
ain37579091_ain
cain65643911cain
fain75840561fain
gain56042161gain
kain85334291kain
lain46146281lain
main65345521main
pain65647241pain
rain46251731rain
sain45551291sain
swain84919051swain
tain45548071tain
twain86313621twain
vain75233001vain
waif105836751waif
wail75238821wail
wains86930871wains
wair75830051wair
wait75553691wait
wan66761941wa_n
warn75239321warn
whin105225691whin
win66456291w_in
again65218122again
agin56132712agin
ai211288392_ai_
aid49269082_aid
ail37171042_ail
aim57858212_aim
ains46158882_ains
air38058392_air
airn46433832_airn
ais39083572_ais
ait38093902_ait
akin86328032akin
amain74922912amain
amin66042252amin
an211879082_a_n
ani37751182_ani
atwain937812atwain
await85524492await
awing96827322awing
awn68035912_awn
ayin76331742ayin
bail65042802bail
bairn77515532bairn
bait66556002bait
ban58366842ba_n
bani65334962bani
barn66444642barn
basin75026922basin
bin56658642_bin
blain75421792blain
blin67228172blin
brain76229382brain
brin67038192brin
cabin94820942cabin
caid77837532caid
cains75334302cains
cairn75717512cairn
can57760142ca_n
carn66245432carn
chain105723672chain
chin96934742chin
coin66645352coin
dais57040702dais
damn75724322damn
dan46859672da_n
darn56434622darn
dawn85624202dawn
din46459462_din
djin12911632djin
drain65222892drain
earn46737552earn
elain55324702elain
fagin9216572fagin
fail74840242fail
faint85837062faint
fair76332522fair
fan67158862fa_n
faun76226622faun
fawn105321952fawn
fin66458032_fin
foin77231562foin
gaen57329602gaen
gains65729512gains
gait56150192gait
gamin84423002gamin
gan48060132ga_n
gaun56427712gaun
gin46055752_gin
grain65126252grain
grin55733722grin
haen76229452haen
haik115526982haik
hail74839062hail
haint85436322haint
hair76330142hair
hin67559562_hin
hwan105716892hwa_n
in28150862__in
jail115529092jail
jin106443932_jin
join116724832join
kaif116933932kaif
kail85131492kail
kains96125642kains
kaon87521022kaon
karn86129412karn
kin76353972_kin
laic65931562laic
laid56439142laid
lair45934152lair
lapin75222922lapin
lawn75925632lawn
layin84720332layin
lin37967372_lin
loin46838722loin
maid75537662maid
mail65543452mail
maim85831492maim
mains75635112mains
mair66133782mair
man57465872ma_n
matin75132852matin
maun65727212maun
mavin105722952mavin
mawn94424142mawn
naan47621932naan
naif76839022naif
nail45838652nail
nan37854882na_n
paid75737482paid
paik105726802paik
pail66141832pail
pains75138282pains
paint75443692paint
pair66031512pair
pan58466452pa_n
patin76832852patin
pavin105623202pavin
pawn94625302pawn
pein65834942pein
pian66136092pian
pin57066722_pin
plain74823302plain
pyin96823232pyin
qaid146023842qaid
quin135823922quin
rai37658222rai_
raia46638382raia
raid55243072raid
rail46147762rail
rains55140232rains
rainy85921082rainy
rais45252622rais
ran38266622ra_n
rani46640112rani
ravin85624652ravin
rawin85521472rawin
rein46040892rein
rin36663182_rin
ruin47430512ruin
sabin74924952sabin
said55742112said
sail45447162sail
sains55639972sains
saint55147072saint
sarin55239252sarin
sasin54626572sasin
satin55935222satin
savin84625082savin
sawn75428162sawn
shin75634312shin
sin36265892_sin
skin85927532skin
slain54923572slain
spin66231302spin
stain55727942stain
swail86217162swail
swains94513952swains
swan76631312swa_n
tail45443652tail
tains54936322tains
taint55542282taint
takin94921302takin
tan37167572ta_n
tarn46842722tarn
thin76732392thin
tin36362172_tin
train56529112train
twains95811182twains
twin76023082twin
tyin76424002tyin
vail75432552vail
vair75624142vair
van66246332va_n
vein75625752vein
wab87051832wa_b
wabs97337232wabs
wack135330912wack
wad77053892wa_d
wade85237062wade
wadi86228172wadi
wading114619532wading
wadis95223962wadis
wads87343142wads
wady115324992wady
wae67556952wa_e
waes76048602waes
waff134228042waff
waft106139002waft
wag76451752wa_g
wage84834082wage
waging114318382waging
wagon94312952wagon
wags86140552wags
wahine123813012wahine
waifs115719872waifs
wails86631482wails
wairs86424062wairs
waist86132382waist
waits88333522waits
waive114214602waive
wake114935702wake
waken124818472waken
waking144821382waking
wale74546432wale
waling104525302waling
walk115625612walk
wall76236102wall
waly105830902waly
wame95035482wame
wand85833882wand
wane76344722wane
waning103623802waning
wanion93213062wanion
wank115632512wank
wans76452272wans
want76156172want
wany106432362wany
wap86553372wa_p
waps96642082waps
war67262422wa_r
ward86542252ward
ware76254722ware
waring105029442waring
wark115737772wark
warm95935672warm
warns87231002warns
warp95635002warp
wars78659802wars
wart77866082wart
wary106740012wary
was68767562wa_s
wash106033812wash
wasp95626852wasp
wast75655852wast
wat67378922wa_t
wats77555882wats
watt75545412watt
wauk115220592wauk
waul76927312waul
waur76819902waur
wave105234732wave
waving134018202waving
wavy136620472wavy
waw97046382wa_w
wawl105321942wawl
waws106834902waws
wax137041182wa_x
waxen154911812waxen
waxing174215282waxing
waxy175918202waxy
way96757662wa_y
ways107737952ways
wean75734352wean
ween75835462ween
weir76019922weir
wen66249602w_en
when105723042when
whid115418872whid
whig115516422whig
whim126220532whim
whine116022812whine
whins114922332whins
whiny144915572whiny
whip125521842whip
whir105519282whir
whit104834172whit
whiz195919942whiz
wig76740382w_ig
wind85533852w_ind
wine74953422w_ine
wing86339222w_ing
wink116435022w_ink
wino75933612w_ino
wins75949172w_ins
winy107034322w_iny
wis66552332w_is
wit66563772w_it
wiz156434152w_iz
won66252062w_on
worn75631752worn
wren78221682wren
wring95920712wring
writ75537912writ
wyn95921442w_yn
wynn105811292wynn
yarn75230042yarn
yawn106219092yawn
yin67648732_yin
zayin174512042zayin
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.283631417.0
2DLD Change Limit298723160.75039829.3
3Display Results3163160.0764157.9
 (SQL Overall)1786913161.109161128.0
 
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.