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

207 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
coloured114830(None) 
cloured103111541c_loured
colored10313471colo_red
colourer1037551colourer
closured11266352closured
clotured11246162clotured
clouded11348832c_louded
clouted104212162c_louted
collared113211142collared
colluded12296452colluded
cologned1237152cologned
colorbred1443952colorbred
coloreds1138092colo_reds
colorer9312522colo_rer
colour85915082colour__
colourers1136472colourers
colours95913412colour_s
colure8314152col_ure_
colures9315132col_ures
conjured18117892conjured
contoured1237292contoured
cultured1137232cultured
decoloured1443082decoloured
floured11289872_floured
honoured1236312honoured
loured74617402__loured
allured8299173_allured
arboured1156253arboured
armoured1165223armoured
bicolored1443953bicolo_red
bloodred1234083bloodred
bloused104310643_bloused
calibred1335053calibred
calloused1244403calloused
callused1135853callused
calqued19306523calqu_ed
captured1336563captured
caroused1149253caroused
cellared11398793cellared
censured11248913censured
chlorid133211833chlo_rid
choired13349343c_hoired
chored125321883c_ho_red
choused135012463c_housed
clamoured1444063clamoured
cleared103612463c_leared
cloaked14368543c_loaked
clocked164112833c_locked
clogged12528653c_logged
clomped14398973c_lomped
cloned94518803c_lo_ned
clonked14429563c_lonked
clopped143611523c_lopped
closed95317963c_lo_sed
closure9278473closure_
closures10228943closures
clothed134010283c_lothed
clotted104011823c_lotted
cloture9238453cloture_
clotures10299023clotures
cloud86716423c_lou__d
clour76617283c_lour__
clours85215083c_lour_s
clouter93511683c_louter
clovered14187363clovered
clowned13447723c_lowned
cloyed125111563c_lo_yed
clued84917683c_l_u_ed
cockered17710213cockered
cocooned1337293cocooned
cocultured1543953cocultured
coendured1344083coendured
coenure968143coenure_
coenures1048673coenures
coffered1737673coffered
cofound1335513cofou_nd
cofounded1643463cofounded
cohered133514693co_hered
cohosted1436133cohosted
coiffured1842603coiffured
coinsured1245503coinsured
cojoined1856293cojoined
coled85540753col___ed
coleseed1147393coleseed
coleuses1039713coleuses
collaged12279963collaged
collard103712923collar_d
collaret103116703collaret
collated113615063collated
colleted113011653colleted
collided12309793collided
collied103316673col_lied
collogued1344073collogued
collude10337983collude_
colluder11276863colluder
colludes11279213colludes
colobuses1346133colobuses
colocated1439613colocated
cologne1039353cologne_
colognes11310603colognes
colone85425003colo_ne_
colonel94213283colo_nel
colones96124433colo_nes
colonies103620013colonies
colonised12248723colonised
colonized212710433colonized
color76123743colo_r__
colorado1145933colo_rado
colorbreed1552213colorbreed
colorers10312183colo_rers
colorized212211773colorized
colormen1247243colormen
colors86622373colo_r_s
colouring1258723colouring
colubrid1344403colubrid
columel1136273col_umel
columned1334923columned
communed15338203communed
commuted15288963commuted
compared153811823compared
compered153414923compered
computed154110943computed
concurred1445663concurred
conduced14136953conduced
confused1437033confused
confuted1437673confuted
conjure16109063conjure_
conjurer17117673conjurer
conjures17119903conjures
conquered2145453conquered
consumed1337923consumed
contused1138443contused
cooed84534343co_o__ed
cooeed95917863co_o_eed
cooeyed1346893co_oeyed
cooked135921363co_o_ked
cooled95224583co_o_led
cooped114821603co_o_ped
coopered133310933coopered
coopted123710763co_opted
coplotted1444793coplotted
coppered153410543coppered
cored85044223c__o_red
cornered11311133cornered
cornuted1137463cornuted
coshered14610293coshered
costumed1365033costumed
cottered112511733cottered
couped115019313c__ouped
coursed104113603c__oursed
courted103514913c__ourted
couture9310613couture_
coutures10311973coutures
covered133315293co_vered
cowered133214643co_wered
culture939393culture_
cultures10310143cultures
cured85932133c___ured
decolored1345663decolo_red
deloused1036973deloused
detoured1036513detoured
devoured1335723devoured
discoloured1553303discoloured
dolour75710133dolour__
dolours8438813dolour_s
favoured1533963favoured
floored11268683_floored
flouted113210813_flouted
glouted9429713_glouted
hollered1237603hollered
honored11310123hono_red
honourer1146243honourer
humoured1444363humoured
inpoured1135813inpoured
laboured1156323laboured
louped95316383__louped
loused74822913__loused
louted74920693__louted
louvred11354663__louvred
lured65427493__l_ured
moldered1237173moldered
moored93814173mo_o_red
motored1039933moto_red
odored8399223_odo_red
polluted1135433polluted
postured1139493postured
poured95116743__poured
recolored1246853recolo_red
repoured1139563repoured
rumoured1143783rumoured
savoured1234793savoured
scoured103811153_scoured
sojourned1761493sojourned
soldered1038153soldered
soloed74515743solo__ed
soured74921863__soured
sulfured1236113sulfured
taboured1156273taboured
tonsured976383tonsured
tortured935843tortured
toured74216153__toured
uncolored1246963uncolo_red
unsoured9310053unsoured
vapoured1434353vapoured
velured1136683vel_ured
volumed13285683vol_umed
voluted11297943vol_uted

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622077.45319611.2
3Display Results2072070.0932225.8
 (SQL Overall)1786912077.70223200.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.