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

259 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
colleted11301165(None) 
collated113615061collated
collected1447961collected
billeted1137642billeted
bulleted1138392bulleted
closeted1135612closeted
collaged12279962collaged
collared113211142collared
collate92919682collate_
collates103019132collates
colleen939532colle_en
college102410432college_
colleger11227922colleger
colleges112410512colleges
collet84030362collet__
collets93517902collet_s
collided12309792collided
collied103316672coll_ied
colluded12296452colluded
competed154113592competed
completed162810262completed
corseted11311472corseted
cosseted1178342cosseted
coveted133011522co_veted
filleted1236602filleted
galleted1038212galleted
hollered1237602hollered
palleted1139862palleted
pelleted1138182pelleted
pollened1157772pollened
polluted1135432polluted
toileted936992toileted
volleyed1543532volleyed
alleged9389313_alleged
balloted1189043balloted
billeter1037563billeter
bolete8519613bo_lete_
boletes9316063bo_letes
bolled94722653boll__ed
bollixed1834483bollixed
bolloxed1834473bolloxed
bolted94617803bo_l_ted
bonneted1136223bonneted
cacheted16148233cacheted
called94126733call__ed
callee84327293calle_e_
callees94117773calle_es
callet84536763callet__
callets93821703callet_s
callused1135853callused
carpeted1338943carpeted
casketed1534953casketed
cellared11398793cellared
celled94420323cell__ed
chapleted1743963chapleted
chelated142610483chelated
ciliated11510943ciliated
cleated103417843c_leated
cleeked14357733c_leeked
clefted13326753c_lefted
cleped115114113c__leped
clewed1225113203c__lewed
clotted104011823c_lotted
clouted104212163c_louted
clovered14187363clovered
coacted123611603co_acted
coaled95022703coal__ed
coalesced1444533coalesced
coalshed1435013coalshed
coapted123911493co_apted
coasted104015943co_asted
coated94927033co__ated
cockered17710213cockered
cockeyed2096123cockeyed
cocreated142710093cocreated
coedited1237823coedited
coempted1535333coempted
coerected1447643coerected
coexerted1944763coexerted
coffered1737673coffered
cohered133514693co_hered
cohosted1436133cohosted
coiled95123933coil__ed
colead94114643co_le_ad
coled85540753co_l__ed
coleseed1147393coleseed
collage102813753collage_
collagen11338563collagen
collages113514233collages
collapsed1443223collapsed
collard103712923coll_ard
collaret103116703collaret
collator10310373collator
collect113314593colle_ct
collectedly1983003collectedly
collector1346393collector
collects12279783collects
colleens1036843colleens
collegers12256833collegers
collegia1146053collegia
colleting12311053colleting
collide103214783collide_
collider113410413collider
collides113214463collides
collie83621993coll_ie_
collier93618153coll_ier
collies94326583coll_ies
colligated1446273colligated
collimated1556083collimated
collocated1546163collocated
collogued1344073collogued
colloid10312873coll_oid
collude10337983collude_
colluder11276863colluder
colludes11279213colludes
colocated1439613colocated
cologned1237153cologned
colored10313473co_lored
coloured1148303coloured
colter84625093co_l_ter
columned1334923columned
combated1539823combated
commented16129603commented
commuted15288963commuted
compered153414923compered
compete134716553compete_
competes144117243competes
complected19295863complected
complete143412053complete_
completer153310413completer
completes153212923completes
complexed23295963complexed
compted143813523co_mpted
computed154110943computed
conceded1438283conceded
conceited14310423conceited
concerted14312113concerted
concreted1439413concreted
confected1739073confected
conflated1539333conflated
confuted1437673confuted
congeed113212313conge_ed
congested1338673congested
connected1438753connected
connoted1138863connoted
consented12311943consented
contented12313043contented
contested12310693contested
convected1738783convected
convened143412223convened
convented15410753convented
converted15311563converted
conveyed17247923conveyed
cooeed95917863co_oe_ed
cooeyed1346893co_oeyed
cooled95224583cool__ed
coopered133310933coopered
coopted123710763co_opted
coplotted1444793coplotted
coppered153410543coppered
copulated142710483copulated
coquetted2154823coquetted
corbeled1338373corbeled
corelated12411823corelated
cornered11311133cornered
cornuted1137463cornuted
coroneted12278323coroneted
corrected1438113corrected
coshered14610293coshered
costed95623113co__sted
coted85033853co___ted
cottered112511733cottered
coulee8323503coule_e_
coulees9315503coule_es
coulter94115593coul_ter
counted103815803co_unted
courted103514913co_urted
covered133315293co_vered
coveter122912063co_veter
cowered133214643co_wered
cowled125218383cowl__ed
cozened19349183co_zened
crocheted1745313crocheted
crocketed1845123crocketed
croqueted2143313croqueted
culled94022473cull__ed
cullet84727313cullet__
cullets94015613cullet_s
cullied104012353cull_ied
curveted1435293curveted
decollated14136283decollated
decollete12124783decollete_
decolletes13123983decolletes
deleted93314903_deleted
depleted12258703depleted
docketed16156583docketed
dolled83518073doll__ed
dollied93811143doll_ied
dolloped1234983dolloped
fellated1239563fellated
fileted1159093_fileted
fleeted113310233_fleeted
foliated1249913foliated
followed15146273followed
fullered1236383fullered
gimleted1243973gimleted
gleeted9379323_gleeted
gorgeted1135353gorgeted
helmeted1435833helmeted
hollaed11359853holl_aed
holloaed12157393holloaed
holloed113812753holl_oed
hollooed12146493hollooed
hollowed15157023hollowed
isleted837523_isleted
jollied15349273joll_ied
jolted143510633jo_l_ted
lolled74315823loll__ed
lolloped1134463lolloped
milleped1335173milleped
moldered1237173moldered
molested11178243molested
molted94217473mo_l_ted
moulted103310313moul_ted
ocellated1245453ocellated
pocketed17147143pocketed
polled94022003poll__ed
pollee83623273polle_e_
pollees93215333polle_es
pollenated1345013pollenated
pollster1037103pollster
pollute937383pollute_
polluter1035403polluter
pollutes1037613pollutes
recollected1643853recollected
rocketed15157793rocketed
rolled74220243roll__ed
roqueted1834653roqueted
rouletted1045053rouletted
scolloped1443653scolloped
sleeted83113223_sleeted
socketed15177343socketed
solated83618023so_lated
soldered1038153soldered
solleret8512223solleret
solvated12237443solvated
sonneted936183sonneted
tableted1137533tableted
telneted935073telneted
tillered937433tillered
tolled73819033toll__ed
trolleyed1342473trolleyed
uncollected1653673uncollected
valeted1139013_valeted
valleyed1534013valleyed
velveted1533833velveted
volleyer1443163volleyer
voluted11297943vo_luted
walleyed1534153walleyed

Search took 7 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 Filter1786911461620.1731032896.0
2DLD Change Limit1461622596.31323152.5
3Display Results2592590.1102354.5
 (SQL Overall)1786912596.59627090.8
 
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.