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

181 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
coloreds113809(None) 
colored10313471colored_
colorers10312181colorers
chlorids14299672chlorids
colonels104210452colonels
colones96124432colone_s
colorado1145932colorado
colorer9312522colore_r
colorless1145682colorless
colors86622372color__s
coloured1148312coloured_
colourers1136472colourers
colures9315142colure_s
beloveds14153963beloveds
bicolored1443953bicolored_
boloneys1334503boloneys
calomels1236133calomels
calorics122810463calorics
calories102919563calories
caloyers1337343caloyers
chlorals13148033chlorals
chlorid133211843chlorid_
chloride143310243chloride
chlorides15289753chlorides
chlorins132612883chlorins
chlorous1339223chlorous
chords125214633c_hor_ds
choreas124414203c_horeas
chored125321883c_hored_
chores114828023c_hore_s
cicorees1246413cicorees
clarets94111103c_larets
clerids1049093c_lerids
clods85320863c_lo__ds
cloned94518803c_loned_
cloners94514823c_loners
clones84526563c_lone_s
closed95317963c_losed_
closers94415323c_losers
closes85425593c_lose_s
closets94611603c_losets
clouds94612353c_lo_uds
cloured103111543cloured_
clovers125114663c_lovers
cloves114918823c_love_s
cloyed125111563c_loyed_
clozes174915563c_loze_s
coalsheds1542863coalsheds
coeds85920163c__o_eds
coelomes1239293coelome_s
coffrets1645363coffrets
cofounds1444713cofounds
cohered133514693cohered_
coherers132310733coherers
coheres122917693cohere_s
cohorts123411103cohor_ts
cojones163512103cojone_s
coldness1137953coldness
colds85726973col___ds
coleads102911423col_eads
coled85540763col__ed_
coles76055063col__e_s
coleseeds1244323coleseeds
coleus86818273col__eus
colies84837053col_ie_s
collards113310193collards
collared113211143collared_
collarets11327333collarets
colleens1036843colleens
collets93517903col_lets
collides113214473collides
collied103316673collied_
colliers103613583colliers
collies94326583collie_s
colloids11310173colloids
colludes11279223colludes
colobus11389373colo_bus
cologned1237153cologned_
colognes11310603colognes
cologs96517353colo__gs
colone85425003colone__
colonel94213283colone_l
colonics123711613colonics
colonies103620013colonies
colons86028683colo__ns
colonus94413443colo_nus
color76123743color___
colorant10414723colorant
colorants1149863colorants
colorbred1443953colorbred_
colorbreeds1651343colorbreeds
colorcast1346553colorcast
colorfast1445033colorfast
colorful1344413colorful
coloring11414843coloring
colorings1247683colorings
colorism122112433colorism
colorisms132810793colorisms
colorist102818993colorist
colorists112313593colorists
colorize192314203colorize
colorized212211773colorized_
colorizers21267603colorizers
colorizes203014523colorizes
colorman1247893colorman
colormen1247243colormen
colorway1644493colorway
colorways1743723colorways
colossus1045183colossus
colourer1037563coloure_r
colours95913443colo_urs
colters93522443col_ters
colubrids1443603colubrids
columels1244813columels
colure8314163colure__
comfreys1843333comfreys
compress1439053compress
concords1358593concor_ds
condores113315643condore_s
congress1138073congress
conoids10813883cono_ids
cooed84534343co_o_ed_
cooeed95917863co_oeed_
cooees85621893co_o_ees
cooers84324563co_o_ers
cooeys114914483co_o_eys
cooked135921363co_oked_
cookers134619463co_okers
cookeys16478503co_okeys
cooled95224593co_oled_
coolers93522493co_olers
coolies93824963coolie_s
coolness1037743coolness
cooped114821603co_oped_
coopers114019483co_opers
cooters94525723co_oters
copyreads1743323copyreads
cords86030623c__or_ds
cored85044223c__ored_
corers85231073c__orers
cores76361853c__ore_s
coronels104012143coronels
coroners104016223coroners
coronets103814363coronets
corrodes111310333corrodes
costrels1038933costrels
covered133315293covered_
coverers132712123coverers
cowards1339613cowar_ds
cowered133214653cowered_
cowherds1735423cowherds
coworkers1854363coworkers
cowsheds1734743cowsheds
coyotes12410703coyote_s
creds85418773c___reds
crores86121163c_rore_s
decolored1345663decolored_
dolorous947843dolorous
dolors75115313dolor__s
floored11268683floored_
floorers11227573floorers
florets1039853_florets
galores82614343galore_s
holards1148433holar_ds
honored11310123honored_
honorees1148773honorees
honorers1139263honorers
kilorads1344423kilorads
lords64923503__lor_ds
lores55045403__lore_s
milords10117853milor_ds
moored93814173mo_ored_
motored1039933motored_
odored8399223_odored_
polypeds1645773polypeds
recolored1246853recolored_
solerets839693solerets
soloed74515743solo_ed_
solonets838233solonets
splores91910953splore_s
uncolored1246963uncolored_

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.423422437.4
2DLD Change Limit1461621816.95321021.4
3Display Results1811810.0632873.0
 (SQL Overall)1786911817.43924020.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.