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

230 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
inlayer103693(None) 
inlayers1135641inlayers
allayer10148212allayer
belayer12339502belayer
bilayer12347802bilayer
delayer113010532delayer
flayer124713562_flayer
inaner62213542in_aner
inflamer1356122inflamer
inflater1149892inflater
inhaler1068052inhaler
inlace82513042inlace_
inlaced10239872inlaced
inlaces92512902inlaces
inlander937222inlander
inlay85214322inlay__
inlays9389872inlay_s
inlier63615362inl_ier
insaner7310442insaner
invader11146452invader
layer84626472__layer
minelayer1453502minelayer
mislayer1337502mislayer
player115215212_player
slayer93916332_slayer
allayed11138063allayed
allayers11156633allayers
analyser11166133analyser
analyzer20155053analyzer
anlace82513923anlace_
anlaces92313733anlaces
anlage72514223anlage_
anlagen8238633anlagen
anlages82414103anlages
anlases72514903anlases
annoyer1095603annoyer
arrayer10136703arrayer
assayer1035573assayer
belayed133610083belayed
belayers13298143belayers
bilayers13296923bilayers
blader93618583_blader
blamer104417143_blamer
blazer174414023_blazer
brayer115315313_brayer
caloyer1238143caloyer
claver113816973_claver
clawer114512783_clawer
clayed125013043_clayed
clayey14407663_clayey
clayier1248323_clayier
decayer13339353decayer
delayed123310763delayed
delayers12268663delayers
dilater83515653dilater
displayer1545833displayer
elater64724203_elater
engager9278603engager
enjoyer1744383enjoyer
enlace82213233enlace_
enlaced102410523enlaced
enlaces92313393enlaces
enlarger944153enlarger
enslaver1144713enslaver
essayer1033943essayer
flaker134916173_flaker
flamer114919123_flamer
flayed134414053_flayed
flayers133912033_flayers
flyer114916253_fl_yer
forayer13368953forayer
gainsayer1342133gainsayer
gayer94519193__gayer
glazer164212263_glazer
gnawer10386953gn_awer
grayer106014543_grayer
hayer114620243__hayer
idler65015663idl__er
idolater936863idolater
iller54821293i_l_ler
imager9108123i_mager
impaler11298393impaler
inane52820343in_ane_
inanes62519803in_anes
inbye10427063in_bye_
incage93513623incage_
incaged114010443incaged
incages103013883incages
incase83615283incase_
incased103612393incased
incases93615973incases
incher114114033in_cher
inciter93113773inciter
incliner1038513incliner
incloser10106733incloser
incomer1169943incomer
indexer15287253indexer
inditer83514233inditer
inducer10318763inducer
infare9313083infare_
infares10313023infares
infer84215033in__fer
inflame1256963inflame_
inflamed1446033inflamed
inflamers1455213inflamers
inflames1377323inflames
inflate10312313inflate_
inflated12410863inflated
inflaters1247543inflaters
inflates11512193inflates
inflator1158033inflator
infuser10298323infuser
ingate73018243ingate_
ingates82716913ingates
ingather1244783ingather
inhale9411513inhale_
inhaled1169333inhaled
inhalers1166643inhalers
inhales10511863inhales
inhauler1163943inhauler
inhumer1275383inhumer
injurer14318473injurer
inker94421093in__ker
inkier104013783in_kier
inlaid7310143inla_id
inland7310313inla_nd
inlanders1036143inlanders
inlands838783inlands
inlaying1247893inlaying
inlet53732403inl__et
inliers73110743inl_iers
inly75622213inl_y__
inmate82917363inmate_
inmates92715783inmates
innage73011573innage_
innages82911303innages
innate63917313innate_
inner54920633in__ner
insane6314883insane_
insider849733insider
insnarer865303insnarer
insurer73312803insurer
intake10510863intake_
intakes11310943intakes
integer837993integer
inter55028493in__ter
interlayer1346923interlayer
intoner7811673intoner
inulase739413inulase_
inulases838763inulases
invade10157853invade_
invaded12127043invaded
invaders12105303invaders
invades11118293invades
invar839513inva__r
inviter104112313inviter
invoker1435363invoker
irater65218353i_rater
islander946103islander
kneader1275893kneader
lacer75833753__lacer
lader65633723__lader
lager65132863__lager
laker95432873__laker
lamer75233703__lamer
laser54633323__laser
later54843923__later
laver85031793__laver
lawyer12386973__lawyer
laxer125420333__laxer
layed95127383__layed
layers93921183__layers
manslayer1442953manslayer
minelayers1543453minelayers
mislayers1445943mislayers
monolayer1444793monolayer
namer75622103_n_amer
nearer64618893_nearer
neater64424313_neater
nonlawyer1542253nonlawyer
nonplayer1444713nonplayer
onager739663on_ager
onlay84212943onlay__
onlays9398713onlay_s
palaver1238753palaver
payer105125723__payer
pillager11278543pillager
placer105117743_placer
planer84122653_planer
plater84427693_plater
played124815033_played
players124313763_players
plyer106214333_pl_yer
prayer114815293_prayer
relater73723143relater
relaxer143410223relaxer
relayed113212753relayed
sayer84926553__sayer
slaker104219273_slaker
slater64429183_slater
slaver94419613_slaver
slayed104716223_slayed
slayers104513323_slayers
slyer85515123_sl_yer
snarer64620843sn_arer
sneaker112910453sneaker
solacer93011103solacer
splayed13357813splayed
sprayer12369043sprayer
stayer94516483_stayer
strayer104312503strayer
swayer125210973_swayer
uneager839753uneager
unlace82215173unlace_
unlaced102913733unlaced
unlaces92513623unlaces
unlade72714153unlade_
unladed92614373unladed
unladen8248653unladen
unlades82612833unlades
unlay84613703unlay__
unlays93810493unlay_s
unloader936643unloader
unmaker13279513unmaker
unplayed1437263unplayed
vilayet1348533vilayet
villager12267503villager
vintager12104823vintager
violater1137253violater
waylayer1743153waylayer

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.1561145455.1
2DLD Change Limit1340272307.42318055.6
3Display Results2302300.0763026.3
 (SQL Overall)1786912307.65523343.0
 
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.