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

246 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
lauwine103637(None) 
lauwines1145711lauwines
lawine93316461la_wine
alumine9412692alumine
cauline92215602cauline
lapwing13308262lapwing
larine63927042la_rine
latrine7715122latrine
lauding93211902lauding
lawines103313562la_wines
lawing104625282la_wing
leucine938072leucine
lupine84013532l_upine
taurine7311362taurine
acauline1046903acauline
aedine73218393_aedine
affine12310503_affine
alanine7316863alanine
alewife1344923alewife
alexine142410543alexine
aline57243153_a_line
alkine104916803_alkine
alpine84417373_alpine
alumin8513543alumin_
alumina9510053alumina
alumines10411683alumines
alumins9512983alumins
alunite7311633alunite
alvine94614583_alvine
amine75835383_a_mine
ammine10314493_ammine
arsine64021043_arsine
audile73315303_audile
auding83616933_auding
augite7312613_augite
auxin121411913_auxin_
auxins13129813_auxins
awing96827323_a_wing
azine146721413_a_zine
baculine1238983baculine
batwing13509813batwing
bauxite1635573bauxite
blawing134012753bla_wing
brucine1138273brucine
calcine11315273calcine
canine83826703ca_nine
caprine11314233caprine
carbine112918643carbine
carline93923613carline
carmine112918483carmine
cassine93817283cassine
causing103614413causing
cawing124322613ca_wing
clawing133812673cla_wing
daubing11358623daubing
dauphine1444493dauphine
dautie72914703dauti_e
dauting93814763dauting
dawing114819823da_wing
dourine8311453dourine
dwine95616143__dwine
elaphine1346113elaphine
elapine9310673ela_pine
entwine1039143entwine
equine151711573equ_ine
famine114318193fa_mine
fanwise1336633fanwise
fanzine1937123fanzine
fascine12510583fascine
flatline11298923flatline
flatwise1443973flatwise
flavine1338453fla_vine
flawing143812563fla_wing
gamine94620153ga_mine
gauging10339963gauging
gauming11319713gauming
glassine9329313glassine
guanine8810543guanine
gwine95513663__gwine
harmine122816193harmine
hauling113714433hauling
hawing134322353ha_wing
haywire1644743haywire
illumine1046083illumine
intwine1038513intwine
jasmine1636643jasmine
jauking19418323jauking
jauping17307193jauping
jawing174414963ja_wing
jawline17137063jawline
kaoline11310143kaoline
labile8315223la_bile
lacewing1435843lacewing
lacing94626233la_cing
lacking143821543lacking
lactone9311403lactone
lacune8169673la_cune
laddie83713173laddi_e
lading84227123la_ding
ladino73615123la_dino
ladling92813393ladling
ladrone83611873ladrone
lagging103316733lagging
lagune7158633la_gune
laicise939333laicise
laicize1838093laicize
lain46146283la__in_
lairing83715343lairing
laking115027043la_king
lalling83519623lalling
lambie103213673lambi_e
lambing123412413lambing
lamiae84817453la_miae
lamina84920443la_mina
laminae93512973la_minae
laming94528363la_ming
lamming123014583lamming
lamping123116003lamping
lancing103314123lancing
landing92819323landing
landline9311443landline
lane45153333la___ne
lanoline8311953lanoline
lapin75222923la_pin_
lapins84520683la_pins
lapping124117023lapping
lapsing103511163lapsing
lapwings14274973lapwings
larding92917873larding
larking123718253larking
lasagne844063lasagne
lashing114422893lashing
lashins103915153lashins
lasing74727983la_sing
lassie64917743lassi_e
lasting84725243lasting
lathing114315693lathing
latina65621143la_tina
latino64120473la_tino
latrines8515003latrines
lattice938433lattice
lattin64316223lattin_
lattins74115483lattins
lauan55216793lau_an_
lauans65113533lau_ans
laughing1335933laughing
laughline1342913laughline
launce8469183lau_nce
laurae64011663lau_rae
laving104623573la_ving
lawings113611473la_wings
lawlike14137073lawlike
lawmen11308593la_wmen
lawn75925633la_w_n_
lawns85215423la_w_ns
lawny115912013la_w_ny
layin84720333la_yin_
laying104525703la_ying
layins93817653la_yins
lazing164821473la_zing
lazulite1745033lazulite
lazurite1745243lazurite
lazying2046673lazying
lemurine1046523lemurine
leonine7311233leonine
leucin839113leucin_
leucines1037273leucines
leucins938103leucins
leucite937753leucite
line46965573l___ine
louie55023513lou_i_e
louping104313983louping
louring83916503louring
lousing83817733lousing
louting83719383louting
lowing104623273l_owing
lubing94114043l_ubing
lucite8313343l_ucite
luging83915293l_uging
lumina84613543l_umina
lune47140493l_u__ne
lupin75215843l_upin_
lupines93912503l_upines
lupins84514463l_upins
luring73820753l_uring
luting75221753l_uting
lysine94210553l_ysine
machine14313493machine
maline84529083ma_line
manwise1239183manwise
marine84230403ma_rine
marline93320953marline
mauling103315683mauling
mawing124020803ma_wing
murine84220023_murine
mutine84420373_mutine
nardine82712573nardine
narine63422553na_rine
neurine7311683neurine
pardine103616723pardine
patine85328123pa_tine
paulin8312983paulin_
paulins9312613paulins
pausing103912813pausing
pawing124519553pa_wing
plausive1344583plausive
poutine93316823poutine
purine85321893_purine
ralline73518413ralline
rapine85023083ra_pine
ratine65131823ra_tine
ratline74517803ratline
ravine95522223ra_vine
rawin85521473ra_win_
rawins95617623ra_wins
routine72615903routine
rusine63916593_rusine
sabine84020393sa_bine
saline65132703sa_line
saltine75018563saltine
sardine83317393sardine
saucing10311003saucing
savine94220283sa_vine
sawing104323813sa_wing
supine84216693_supine
swine85625303__swine
tacrine9311293tacrine
tagline82412453tagline
taurines8310553taurines
tauting83316383tauting
tawie84819813ta_wi_e
tawing104521553ta_wing
taxwise1734253taxwise
twine85822363__twine
untwine1038623untwine
urine55026603__urine
vaccine1437323vaccine
vahine123612113va_hine
valine94623093va_line
wahine123813013wa_hine
wauking153410013wauking
wauling112713113wauling
waxwing2154723waxwing
wine74953423___wine
yauping13357243yauping
yawing134215613ya_wing

Search took 8 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.406440125.6
2DLD Change Limit1340272466.56320421.6
3Display Results2462460.0932645.2
 (SQL Overall)1786912467.06225303.2
 
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.