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

220 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
layout951370(None) 
layouts1046481layouts
payout11714651payout
about75229082_about
bayou10512362bayou_
bayous11411142bayous
buyout11310102buyout
grayout1148502grayout
labour84210932labour
layabout1345162layabout
layoff1545092layoff
layup1037722lay_up
lout45952142l__out
mahout11415802mahout
payouts1247302payouts
ragout7317182ragout
tryout9410752tryout
abort76133583_abort
abut66834953_a_but
adopt81219743_adopt
afoot8420113_afoot
afoul8510193_afoul
agouti7388763_agouti
agouty10366913_agouty
aliyot93611713aliyo_t
allot54933873allo_t
almost81014433almost
aloft8423433_aloft
aloud65018063_aloud
amort75832203_amort
amount8414483_amount
amour75014853_amour
aport75432173_aport
backout15612953backout
bailout9414133bailout
barbut104617003barbut
bayonet121212213bayonet
blackout1647413blackout
blowout1248403blowout
bout66353293__bout
bugout9311863bugout
buyouts1235203buyouts
cahoot11416473cahoot
campout13412853campout
caput9823973ca_put
carryout1346783carryout
catgut9310793catgut
cavort11316173cavort
clafouti1342903clafouti
clamour1196323clamour
clout75330463_clout
copout10418773copout
cutout8315923cutout
dacoit9415443dacoit
dakoit11310333dakoit
daut56443563da__ut
daylit10512493daylit
devout10712993devout
dimout9414243dimout
dugout8310363dugout
fadeout11410193fadeout
fagot9323403fago_t
fallout10313503fallout
famous11412393famous
favour12438333favour
flameout1347993flameout
flavour1334633flavour
flout86226203_flout
galoot72719153galoot
gamut8322983ga_mut
gavot9321113gavo_t
gayest104314333gayest
glamour1065133glamour
glout65925813_glout
gout56646003__gout
grayouts1244683grayouts
grout65330423_grout
guyot9314523guyo_t
hagbut1278913hagbut
handout11314103handout
hangout11411393hangout
haut75949733ha__ut
hayloft1696963hayloft
jabot14321513jabo_t
joyous16276763joyous
kaput11717063ka_put
kayo116417553kayo__
kayoed14416903kayoed
kayoes134710823kayoes
kayos127714703kayo_s
knout95018263_knout
labium10410233labium
labor75117313labo_r
labors84016403labors
labours9349883labours
labret8320223labret
labrum1057423labrum
ladybug1441473ladybug
lagoon7410483lagoon
lament85024943lament
lamest84722763lamest
lancet84223573lancet
langue71012173langue
languet8713693languet
langur7109303langur
lanose6313593lanose
lapful1156483lapful
lappet103817723lappet
lapsus8437273lapsus
lariat6629043lariat
larrup835713larrup
larum74317973la_rum
last46260323la__st
lat37593403la___t
latent64124303latent
latest63822703latest
latu47934183la_tu_
laud56527723la__ud
lawful1235493lawful
lawsuit1044953lawsuit
laxest134913363laxest
lay68865353lay___
layabouts1442573layabouts
layed95127383lay_ed
layer84626473lay_er
layers93921183layers
layette1037133layette
layin84720333lay_in
laying104525703laying
layins93817653layins
layman113511303layman
laymen113010843laymen
layoffs1642573layoffs
layover1334433layover
lays76043253lay__s
layups1133993layups
linocut997673linocut
lirot5430033liro_t
lockout1359333lockout
loft76539143l__oft
lookout1148033lookout
loot46955823l__oot
lost47951493l__ost
lot38179263l__o_t
loud55228043l__oud
loup66028433l__oup
lour45430683l__our
louts56330273l__outs
lupous849433lupous
lyart85121883l_yart
magot8326393mago_t
mahouts1237143mahouts
maut65448443ma__ut
mayest114614793mayest
mayo96524293mayo__
mayor106616623mayo_r
mayors115714193mayors
mayos105521933mayo_s
mayst106622673may_st
out38072153___out
padouk1336683padouk
parous84024163parous
payoff1736023payoff
payola11208113payola
payor105413843payo_r
payors114312643payors
pigout9314613pigout
playact1446553playact
playful1544653playful
playlet1239523playlet
playoff1843533playoff
playsuit1343773playsuit
pout65752553__pout
poyou102611523poyou_
poyous112911623poyous
putout8315113putout
ragouts838533ragouts
rainout7314393rainout
ramous8417103ramous
rayon83815703rayo_n
rayons94113343rayons
readout8615493readout
redout71820253redout
rout46153283__rout
rubout8313553rubout
runout6414873runout
ryot75528563_ryo_t
sabot7931773sabo_t
sacbut10811943sacbut
sagbut959753sagbut
sajou12311693sajou_
sajous13310583sajous
sapour83812373sapour
savour94110703savour
sayest94217743sayest
sayst85322003say_st
scout75031453_scout
setout64719463setout
shout85433163_shout
slipout949083slipout
snout54530633_snout
spout75029633_spout
sprout8419403sprout
stout57434053_stout
tabour84011313tabour
takeout1149873takeout
tarot55943933taro_t
taut47048963ta__ut
tout46753823__tout
trout57332573_trout
tryouts1035293tryouts
valour93010373valour
vapour11378873vapour
walkout1447933walkout
walnut939433walnut
washout13410133washout
you66641823__you_
your78623433__your
yous76230653__yous
youth115315043__youth

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162205.70319764.3
3Display Results2202200.0802750.0
 (SQL Overall)1786912205.92330169.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.