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

358 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
lain4614628(None) 
ain37579091_ain
blain75421791blain
cain65643911cain
elain55324701elain
fain75840561fain
gain56042161gain
kain85334291kain
laic65931561laic
laid56439141laid
lair45934151lair
lapin75222921lapin
lawn75925631lawn
layin84720331layin
lin37967371l_in
loin46838721loin
main65345511main
pain65647241pain
plain74823301plain
rain46251731rain
sain45551291sain
slain54923571slain
tain45548071tain
vain75233001vain
wain75840191wain
again65218112again
agin56132712agin
ai211288392_ai_
aid49269072_aid
ail37171042_ail
aim57858212_aim
ains46158882_ains
air38058392_air
airn46433832_airn
ais39083572_ais
ait38093902_ait
akin86328032akin
alan46844082alan
alanin6317272alanin
algin65718762algin
alien56425582alien
alif76242142alif
align65016502align
aline57243152aline
alit46155692alit
aloin55227412aloin
amain74922892amain
amin66042252amin
an211879072_a_n
ani37751172_ani
awn68035912_awn
ayin76331742ayin
bail65042802bail
bairn77515532bairn
bait66556002bait
ban58366832ba_n
bani65334952bani
barn66444642barn
basin75026922basin
bin56658642_bin
blains84516372blains
blawn106813702blawn
blin67228172blin
brain76229382brain
brin67038192brin
cabin94820942cabin
caid77837532caid
cains75334302cains
cairn75717512cairn
can57760132ca_n
carn66245432carn
chain105723672chain
chin96934742chin
claim95616912claim
clan65633922cla_n
coin66645352coin
dais57040702dais
damn75724322damn
dan46859662da_n
darn56434622darn
dawn85624202dawn
din46459462_din
djin12911632djin
drain65222892drain
earn46737552earn
elains64919852elains
elan46734242ela_n
elfin84312462elfin
eloin55923202eloin
fagin9216572fagin
fail74840242fail
faint85837062faint
fair76332522fair
fan67158852fa_n
faun76226622faun
fawn105321952fawn
fin66458032_fin
flail85316182flail
flair86114122flair
flan76134182fla_n
flavin1239302flavin
foin77231562foin
gaen57329602gaen
gains65729512gains
gait56150192gait
gamin84422992gamin
gan48060122ga_n
gaun56427712gaun
gin46055752_gin
glair65313552glair
grain65126252grain
grin55733722grin
haen76229452haen
haik115526982haik
hail74839062hail
haint85436322haint
hair76330142hair
hin67559562_hin
in28150862__in
jail115529092jail
jin106443932_jin
join116724832join
kaif116933932kaif
kail85131492kail
kains96125642kains
kaon87521022kaon
karn86129412karn
kin76353962_kin
la219261632la__
lab58864782la_b
labia75219012labia
labs67145122labs
lac510155822la_c
lace66848472lace
lacing94626232lacing
lack105837682lack
lacs66942482lacs
lacy95829632lacy
lad48165702la_d
lade56345982lade
laden65022192laden
lading84227122lading
ladino73615122ladino
lads56549132lads
lady86527152lady
lag47862122la_g
lagan66520342lagan
lags56546222lags
laich105920712laich
laics76419252laics
laigh95515922laigh
laird65417792laird
lairs55425872lairs
laith85722102laith
laity85318902laity
lake85741602lake
lakh114919952lakh
laking115027042laking
laky116725822laky
lall45531312lall
lam57666712la_m
lama66635292lama
lamb86832142lamb
lame66849292lame
lamia75324322lamia
lamina84920442lamina
laming94528362laming
lamp86233822lamp
lams66552262lams
land56337302land
lane45153322lane
lang56637372lang
lank84734442lank
lap58565272la_p
lapins84520682lapins
lapis76223152lapis
laps66848872laps
lar37967532la_r
lard56742002lard
lari45839152lari
larine63927042larine
laris54737462laris
lark85733862lark
lars46956572lars
las37281472la_s
lase46148512lase
lash76539652lash
lasing74727982lasing
lass47444542lass
last46260322last
lat37593402la_t
late47560482late
laten54328342laten
lath76640382lath
lati46438272lati
latina65621142latina
latino64120472latino
lats45962702lats
lattin64316222lattin
latu47934182latu
lauan55216792lauan
laud56527722laud
lav66847342la_v
lava76725422lava
lave75642142lave
laving104623572laving
lavs76734152lavs
law68656642la_w
lawine93316462lawine
lawing104625282lawing
lawns85215422lawns
lawny115912012lawny
laws76441682laws
lax107651522la_x
lay68865352la_y
laying104525702laying
layins93817652layins
lays76043252lays
laze136235052laze
lazing164821472lazing
lazy166423072lazy
lean46345242lean
learn55322662learn
lei36846382lei_
leis45739602leis
levin84816412levin
li29948752l_i_
liana53915892liana
liane54720662liane
liang64914412liang
liar47229682liar
lib57750272l_ib
lid47453512l_id
lie38264522l_ie
lien45339802lien
limn66527692limn
line46965572l_ine
ling57447962l_ing
linin58025522linin
link86943442l_ink
linn46034592linn
lino46343372l_ino
lins47059052l_ins
lint416266232l_int
liny78141322l_iny
lion46334442lion
lip514755802l_ip
lipin75518892lipin
lis37162272l_is
lit39377312l_it
loan47436452loan
login66025002login
loid55531482loid
loins56728422loins
loon47344792loon
lorn46435252lorn
lown76929292lown
lupin75215842lupin
lying95717452lying
lysin84512782lysin
maid75537642maid
mail65543442mail
maim85831482maim
mains75635102mains
mair66133772mair
man57465852ma_n
matin75132852matin
maun65727202maun
mavin105722952mavin
mawn94424132mawn
naan47621932naan
naif76839022naif
nail45838652nail
nan37854872na_n
olein5316002olein
paid75737482paid
paik105726802paik
pail66141832pail
pains75138282pains
paint75443692paint
pair66031512pair
pan58466442pa_n
patin76832852patin
pavin105623202pavin
pawn94625302pawn
pein65834942pein
pian66136092pian
pin57066722_pin
plaid85118302plaid
plains85019592plains
plaint85323202plaint
plait75631572plait
plan65833942pla_n
pyin96823232pyin
qaid146023842qaid
quin135823922quin
rai37658222rai_
raia46638382raia
raid55243072raid
rail46147762rail
rains55140232rains
rainy85921082rainy
rais45252622rais
ran38266612ra_n
rani46640102rani
ravin85624652ravin
rawin85521472rawin
rein46040892rein
rin36663182_rin
ruin47430512ruin
sabin74924952sabin
said55742112said
sail45447162sail
sains55639972sains
saint55147072saint
sarin55239252sarin
sasin54626572sasin
satin55935212satin
savin84625082savin
sawn75428162sawn
shin75634302shin
sin36265892_sin
skin85927522skin
spin66231302spin
stain55727932stain
swain84919052swain
tail45443652tail
tains54936322tains
taint55542282taint
takin94921302takin
tan37167562ta_n
tarn46842722tarn
thin76732382thin
tin36362172_tin
train56529112train
twain86313622twain
twin76023082twin
tyin76424002tyin
ulan46527392ula_n
vail75432552vail
vair75624142vair
van66246322va_n
vein75625752vein
waif105836752waif
wail75238822wail
wains86930862wains
wair75830052wair
wait75553692wait
wan66761932wa_n
warn75239322warn
whin105225692whin
win66456292_win
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.0632836365.1
2DLD Change Limit298723580.97030795.9
3Display Results3583580.0933849.5
 (SQL Overall)1786913581.126158695.4
 
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.