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

124 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
color7612374(None) 
colog86619931colog
colon78630191colon
colors86622371colors
colour85915081colour
dolor67617961dolor
bicolor1145612bicolor
bolar75123472bolar
bolo65535952bolo_
bolos75531372bolos
boor66130682bo_or
calo64936442calo_
calory11312842calory
calos74431902calos
celom9515682celom
choler113717152choler
cholo105217972cholo_
cholos114716852cholos
clod76124612c_lod
clog76123242c_log
clon66232482c_lon
cloot76127052cloot
clop86929892c_lop
clot66542422c_lot
clour76617282clour
cloy96623832c_loy
coaler84121702coaler
coco87330602coco_
cocoa98517882cocoa
cocos95624692cocos
coder86134212coder
codon86522852codon
coelom10310422coelom
cogon89120902cogon
coho97524492coho_
cohog117813042cohog
cohort1110720262cohort
cohos105921852cohos
coiler84421592coiler
coir66327242co_ir
col59360352col__
cola66541392col_a
colas75436772colas
colby124415062colby
cold77338772col_d
colder95121832colder
colds85726972colds
cole66956112col_e
coled85540752coled
coles76055062coles
colic95726172colic
colin76231692colin
collar83816172collar
collop107312302collop
colly104926772colly
colobi105011082colobi
cologs96517352cologs
colone85425002colone
coloni85619202coloni
colons86028672colons
colony115417262colony
colored10313472colored
colorer9312522colorer
colours95913412colours
cols66553082col_s
colt67158242col_t
colter84625092colter
colts76633292colts
colure8314152colure
coly96940532col_y
colza165112982colza
comer95832692comer
condor94616962condor
coo59566362co_o_
cooer74831012cooer
coof96643272co_of
cook107236932co_ok
cool66940492co_ol
cooler84824712cooler
cools75632632cools
cooly105525422cooly
coon67248942co_on
coop87238652co_op
coos67456492co_os
coot67860382co_ot
coper95336092coper
coplot10518272coplot
cor59960942c__or
corer75538872corer
couloir936142couloir
cover105430772cover
cower104531772cower
coyer105222842coyer
cruor7310442cruor
decolor1087032decolor
dolors75115312dolors
dolour75710132dolour
donor64418192donor
door56928512do_or
floor84215232floor
honor85718622honor
kolo87026222kolo_
kolos94921212kolos
molar75223092molar
moor66628552mo_or
motor75317292motor
nolo46229312nolo_
nolos54423352nolos
odor55718092_odor
polar75623452polar
poler74431792poler
polo66236632polo_
polos76129902polos
poor65630222po_or
recolor978692recolor
rotor55519732rotor
solar55927342solar
solo45538942solo_
solon55026132solon
solos54830792solos
sopor74016492sopor
tolar55524112tolar
valor83614892valor
volar86917412volar

Search took 3 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 Filter178691538000.1731032896.0
2DLD Change Limit538001242.23324093.1
3Display Results1241240.0304133.3
 (SQL Overall)1786911242.43673354.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.