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 “coft” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

241 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
coft9793968(None) 
coat67558341coat
coff126930781coff
colt67158241colt
coot67860381coot
cost68057941cost
cot510483221co_t
croft105622681croft
loft76539141loft
oft67744061_oft
soft76942821soft
toft77441651toft
aft66849012_aft
aloft8423432aloft
boat66360312boat
boff124727322boff
bolt66254172bolt
boot67759372boot
bort65960962bort
bot59680402bo_t
bott66548572bott
bout66353292bout
cafe95230322cafe
caff125631672caff
cant66362022cant
cart66570342cart
cast67159902cast
cat58282342c_at
celt65646712celt
cent67451012cent
chat95546132chat
chit96937462chit
chott103923922chott
cist67244962cist
cleft106222852cleft
clift106422192clift
cloot76127052cloot
clot66542422clot
clout75330462clout
coact96130572coact
coal66939252coal
coapt96131522coapt
coast75236262coast
coati75624632coati
coats75634992coats
coax136922972coax
cob710258752co_b
cobb106421992cobb
cobs87043142cobs
coca88030642coca
cock126332902cock
coco87330602coco
cod69660122co_d
coda77029342coda
code77347732code
cods76848102cods
coed77140542coed
coffs134916302coffs
cog69552902co_g
cogs77340032cogs
coho97524492coho
coif96337902coif
coifs105718702coifs
coil66439652coil
coin66645352coin
coir66327242coir
coke107038382coke
coky137526822coky
col59360352co_l
cola66541392cola
cold77338772cold
cole66956112cole
cols66553082cols
colts76633292colts
coly96940532coly
coma87134852coma
comb106632112comb
come87547702come
comet95946072comet
comfit133112422comfit
comfy153710212comfy
comp106731252comp
compt116328222compt
comte96125472comte
con510268022co_n
cone67256962cone
confit113316402confit
coni65534802coni
conk106531442conk
conn66229132conn
cons66057692cons
conte76633202conte
conto76027172conto
cony96537832cony
coo59566362co_o
coof96643272coof
coofs105924712coofs
cook107236932cook
cool66940492cool
coon67248942coon
coop87238652coop
coopt95929852coopt
coos67456492coos
coots75636842coots
cop711162372co_p
cope86847382cope
cops86751372cops
copy116229802copy
cor59960942co_r
cord76740922cord
core67263112core
corf95941482corf
cork106635692cork
corm85735372corm
corn69945812corn
cors66656442cors
cory96941512cory
cos510270392co_s
coset75748842coset
cosh96127622cosh
coss66143492coss
costa75523732costa
costs77231142costs
cosy97232702cosy
cote66648732cote
cots68054842cots
cotta75818572cotta
count74932052count
coup86729792coup
court75532762court
couth106122482couth
cove95837072cove
covet105638942covet
cow89856712co_w
cowl97530812cowl
cows97046642cows
cowy126427362cowy
cox1210346782co_x
coxa136922962coxa
coy810557552co_y
coys97537242coys
coz149345362co_z
cozy185823802cozy
craft105327662craft
crit65743712crit
crofts114910592crofts
cuff125327992cuff
cult66541152cult
cunt66243672cunt
curt67051712curt
cut57957662c_ut
cyst96322812cyst
daft85537252daft
deft85540222deft
doat56947672doat
doff116225782doff
doit56347852doit
dolt56649422dolt
dost57248352dost
dot47573182do_t
eft66038822_eft
font77143752font
foot76248012foot
fort76456442fort
gift86735792gift
goat56250832goat
got49870442go_t
gout56646002gout
haft105941842haft
heft106736292heft
holt77852582holt
hoot75752092hoot
host77852832host
hot67776052ho_t
jolt116639122jolt
jot108259022jo_t
left76340482left
lift76942722lift
lofts85518362lofts
lofty115813302lofty
loot46955822loot
lost47951492lost
lot38179262lo_t
lout45952142lout
moat66352032moat
molt66356162molt
moot67653622moot
mort66758832mort
most66554202most
mot57279422mo_t
mott66648442mott
not39474662no_t
nowt78833752nowt
oat39888262_oat
of58247772_of_
off96331632_off
oot311274692_oot
opt57545542_opt
ort39465232_ort
out38072152_out
pfft12311882pfft
poet65552902poet
port66059632port
post67953362post
pot58078432po_t
pout65752552pout
raft76245912raft
reft75141272reft
rift75642332rift
root45655922root
rot37282952ro_t
rout46153282rout
scoff134413342scoff
scoot75729142scoot
scot66242602sco_t
scout75031452scout
sift710740662sift
sofa75625602sofa
softa86415182softa
softs85019232softs
softy115414482softy
soot45761052soot
sort46264812sort
sot310384292so_t
toff105929902toff
tofts84919242tofts
tofu76921332tofu
toit46353062toit
toot45958882toot
tort46967462tort
tost48351922tost
tot38884772to_t
tout46753822tout
tuft76929512tuft
volt76439532volt
waft106139002waft
weft105435012weft
wont75842502wont
wort76654752wort
wost76544362wost
wot610467482wo_t

Search took 2 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 Filter178691298720.0602978183.3
2DLD Change Limit298722411.67317855.3
3Display Results2412410.0932591.4
 (SQL Overall)1786912411.82697859.3
 
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.