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 “payout” 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
payout1171465(None) 
layout9513701layout
payouts1247301payouts
about75229082_about
bayou10512362bayou_
bayous11411142bayous
buyout11310102buyout
grayout1148502grayout
layouts1046482layouts
mahout11415802mahout
padouk1336682padouk
parous84024162parous
payoff1736022payoff
payola11208112payola
payor105413842payo_r
payors114312642payors
pigout9314612pigout
pout65752552p__out
poyou102611522poyou_
poyous112911622poyous
putout8315112putout
ragout7317182ragout
tryout9410752tryout
abort76133583_abort
abut66834953_a_but
adopt81219743_adopt
afoot8420113_afoot
afoul8510193_afoul
agouti7388763_agouti
agouty10366913_agouty
aloft8423433_aloft
aloud65018063_aloud
amort75832203_amort
amount8414483_amount
amour75014853_amour
aport75432173_aport
backout15612953backout
bailout9414133bailout
barbut104617003barbut
bayonet121212213bayonet
bout66353293__bout
bugout9311863bugout
buyouts1235203buyouts
cahoot11416473cahoot
campout13412853campout
caput9823973ca_put
carryout1346783carryout
catgut9310793catgut
cavort11316173cavort
clout75330463_clout
copout10418773copout
cutout8315923cutout
dacoit9415443dacoit
dakoit11310333dakoit
daut56443563da__ut
daylit10512493daylit
devout10712993devout
dimout9414243dimout
dugout8310363dugout
fadeout11410193fadeout
fagot9323403fago_t
fallout10313503fallout
famous11412393famous
favour12438333favour
flout86226203_flout
galoot72719153galoot
gamut8322983ga_mut
gavot9321113gavo_t
gayest104314333gayest
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
labour84210933labour
layabout1345163layabout
layoff1545093layoff
layup1037723lay_up
lout45952143__lout
magot8326393mago_t
mahouts1237143mahouts
maut65448443ma__ut
mayest114614793mayest
mayo96524293mayo__
mayor106616623mayo_r
mayors115714193mayors
mayos105521933mayo_s
mayst106622673may_st
out38072153___out
pablum1237503pablum
packet144726503packet
pact86648723pa__ct
padauk1335643padauk
padouks1434863padouks
paeon74819493paeo_n
paeons83915523paeons
pagod95013683pago_d
pagoda10487873pagoda
pagods105310193pagods
paint75443693pa_int
pakora1247283pakora
palest83926223palest
palet74650803pa_let
pallet84232653pallet
palpus104210283palpus
pandit93820753pandit
pandour10408213pandour
panful1179743panful
pant66061253pa__nt
pantoum1138703pantoum
papist102618743papist
pappous1057463pappous
pappus9408373pappus
papyrus1444063papyrus
parent83230423parent
pareu74928743pareu_
pareus85420743pareus
parget94529393parget
parlour937263parlour
parlous9414293parlous
parody12410093parody
parol74826273paro_l
parole84425253parole
parols84722613parols
paroquet1947283paroquet
parquet18311583parquet
parrot8320663parrot
part65967463pa__rt
passus83610293passus
past65959013pa__st
pat58089463pa___t
patent84524923patent
patois84319363patois
paviour1244623paviour
pay88461183pay___
payday1536613payday
payed115925933pay_ed
payee105524723pay_ee
payees114812903payees
payer105125723pay_er
payers114621823payers
paying123722163paying
payload1336393payload
payment14310703payment
paynim1337363paynim
payoffs1843243payoffs
payolas12148973payolas
payroll1245613payroll
pays95940223pay__s
peacoat11412913peacoat
peanut8318183peanut
peyote1139853peyote
peyotl1146233peyotl
phaseout1346783phaseout
phot95534353p_ho_t
phut96925973p__hut
phylum1655153phylum
picot95031013pico_t
pignut9311573pignut
pigouts1037593pigouts
pilot77435063pilo_t
pilous84717753pilous
pinot78737293pino_t
pious74621273p_ious
pivot106523873pivo_t
playact1446553playact
playful1544653playful
playlet1239523playlet
playoff1843533playoff
playsuit1343773playsuit
plot66141233p_lo_t
poet65552903p__oet
porous84419483porous
port66059633p__ort
post67953363p__ost
pot58078433p__o_t
pouf95732643p__ouf
poult76928873p__oult
pour611527473p__our
pouts75530323p__outs
pouty107018813p__outy
precut102016533precut
prost75434103p_rost
proud84615483p_roud
psyops1334343psyops
pullout9310593pullout
put55759073p___ut
putouts937083putouts
pyoid11513753p_yoid
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
snout54530633_snout
spinout9311583spinout
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.1261418182.5
2DLD Change Limit1127162465.01322484.7
3Display Results2462460.0803075.0
 (SQL Overall)1786912465.21934238.6
 
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.