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

247 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
loyaler103508(None) 
coaler84121712co_aler
loader74316312lo_ader
loafer93610942lo_afer
loaner64416502lo_aner
locale83915652locale_
locales93715092locales
locater93113602locater
loller63315282lo_ller
loyal84513482loyal__
loyalest11146722loyalest
loyally13126842loyally
loyalty13114342loyalty
voyager1433512voyager
baler75635273__baler
bloater94013423blo_ater
boater84622093bo_ater
boggler113910083boggler
boiler84319273bo_iler
boodler103312003boodler
bottler94211883bottler
bowler114217313bo_wler
boyar106013763boya__r
coaled95022713co_aled
coalers94419353co_alers
coalier93416183co_alier
coater84329573co_ater
coaxer153912793co_axer
cobbler133311823cobbler
coddler113710833coddler
coiler84421593co_iler
comaker153410603comaker
cooler84824713co_oler
coruler9311713coruler
coupler114713013coupler
coyer105222843coy__er
cycler1335913_cycler
dealer74122143_dealer
dialer74315433_dialer
doodler93310153doodler
doubler103110083doubler
dowager1245803dowager
doyley13487283doy_ley
empaler11288353empaler
floater104413353flo_ater
foaled104515963fo_aled
foamer114714313fo_amer
fondler11348883fondler
footler104011873footler
foozler19397593foozler
forager114412563forager
forayer13368953forayer
fouler93614903fo_uler
fowler123712583fo_wler
foyer116416553foy__er
gloater83711013glo_ater
goaled85014363go_aled
gobbler123310023gobbler
goggler10379323goggler
haler85033523__haler
healer94221803_healer
hoaxer16348563ho_axer
hobbler143710403hobbler
holler93520613ho_ller
homager13107853homager
hostler103411023hostler
howler123514313ho_wler
hoyle11314413hoy_le_
hoyles12315013hoy_les
impaler11298393impaler
inhaler1068053inhaler
joggler16398833joggler
jostler14288223jostler
kayaker1354503kayaker
laager74312783l_aager
labeler92310183labeler
lacer75833753l__acer
lader65633723l__ader
ladler74314933l_adler
lager65132863l__ager
laker95432873l__aker
lamer75233703l__amer
landler84113203landler
laser54633323l__aser
later54843923l__ater
lavalier1146043lavalier
laver85031793l__aver
laxer125420333l__axer
layer84626473l__ayer
layover1334433layover
leader74824653l_eader
leaker104620073l_eaker
leaner64022193l_eaner
leaper88118943l_eaper
leaser65322673l_easer
leaver94321513l_eaver
leveler10399903leveler
libeler9219003libeler
littler7348553littler
loaded84616873lo_aded
loaders83413433lo_aders
loafed104011153lo_afed
loafers10349463lo_afers
loamed94414613lo_amed
loamier9349163loamier
loaned73816293lo_aned
loaners73913623lo_aners
loather103711003loather
loaves94813853lo_aves
lobar7313013loba__r
lobate82915243lobate_
lobated102610943lobated
lobber104016603lo_bber
lobbyer1433913lobbyer
lobster9288853lobster
lobular936663lobular
lobule82910063lobule_
lobules92510813lobules
local74820273local__
localizer20147713localizer
locally12179723locally
locals83714503local_s
locate83919843locate_
located103114183located
locaters102710073locaters
locates93218813locates
locator93110423locator
locker124019423lo_cker
locular938953locular
locule83412033locule_
loculed10317653loculed
locules92812603locules
lodger86517693lo_dger
lofter94614723lo_fter
loftier1037763loftier
logger86420003lo_gger
loggier93811143loggier
logier75015733lo_gier
loiter64619173lo_iter
lolled74315823lo_lled
lollers72713793lo_llers
lonelier838003lonelier
loner55431043lo__ner
longer75823203lo_nger
looker104816953lo_oker
loonier73312683loonier
looper83817113lo_oper
loopier93711193loopier
looser65219943lo_oser
looter64222323lo_oter
loper75129233lo__per
lopper103717203lo_pper
loppier11369723loppier
loral55927823loral__
lordlier935363lordlier
lorimer937753lorimer
loriner7511893loriner
losable91910953losable_
loser54728673lo__ser
lotter64025603lo_tter
louder74414603lo_uder
loudlier934953loudlier
lounger84610213lounger
lousier72411623lousier
louver94110393lo_uver
lovable12179553lovable_
lovage1037353lovage_
lovages1138033lovages
lovelier1136433lovelier
lover85526453lo__ver
lower85830413lo__wer
lowlier10338903lowlier
loyalism13167573loyalism
loyalist111511133loyalist
loyalties1244483loyalties
luller63415483l_uller
lyase85512413l_yase_
lyases95211873l_yases
moaner84415113mo_aner
modeler1039293modeler
moiler84017263mo_iler
morale85220553morale_
morales93619403morales
mottler94410343mottler
nobbler113211183nobbler
nobler83713453no_bler
nopales93812523nopales
noyade1036423noyade_
noyades1136563noyades
oater55433733_o_ater
ogler65917443_o_gler
oiler54628283_o_iler
onager739663_onager
ostler63312193_ostler
oyer75927653_oy__er
oyster94111703_oyster
paler75436933__paler
pedaler103410693pedaler
poler74431793po__ler
poller83921853po_ller
pooler83819843po_oler
realer63528593_realer
regaler83814623regaler
roamer84715163ro_amer
roarer63914333ro_arer
roller63919793ro_ller
royal85014703royal__
royally13157733royally
royals93711263royal_s
royalty13165113royalty
royster103110533royster
scaler84321603_scaler
sealer63928963_sealer
shoaler102610083shoaler
soaker105717533so_aker
soaper84517873so_aper
soarer64522243so_arer
socager10107703socager
solacer93011103solacer
staler64025823_staler
stealer72913983stealer
styler94013303sty_ler
taler56034863__taler
thaler94613103_thaler
toddler9379043toddler
toggler9399193toggler
toiler63918283to_iler
toller63819443to_ller
tooler63818613to_oler
tootler73511123tootler
totaled839693totaled
toyer84521553toy__er
vealer94016543_vealer
voyage1335473voyage_
voyaged1533513voyaged
voyagers1532813voyagers
voyages1435703voyages
voyageur154853voyageur
waler84229263__waler
whaler124611973_whaler
wobbler14329823wobbler
wooler93615873wo_oler
yager95616753__yager
yarer84321573__yarer
yodeler1136343yodeler
yodler10389943yo_dler
yowler123310043yo_wler

Search took 10 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 Limit1340272479.14014663.8
3Display Results2472470.0932655.9
 (SQL Overall)1786912479.65618505.7
 
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.