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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
colog8661993(None) 
clog76123241c_log
cohog117813041cohog
cologs96517351cologs
colon78630191colon
color76123741color
apolog938902apolog
blog75723822_blog
bolo65535952bolo_
bolos75531372bolos
calo64936442calo_
calos74431902calos
celom9515682celom
cholo105217972cholo_
cholos114716852cholos
clag75924572c_lag
clod76124612c_lod
clogs85519552c_logs
clon66232482c_lon
cloot76127052cloot
clop86929892c_lop
clot66542422c_lot
cloy96623832c_loy
coco87330602coco_
cocoa98517882cocoa
cocos95624692cocos
codon86522852codon
coelom10310422coelom
cog69552902c__og
cogon89120902cogon
coho97524492coho_
cohogs125810272cohogs
cohos105921852cohos
col59360352col__
cola66541392col_a
colas75436772colas
colby124415062colby
cold77338772col_d
colds85726972colds
cole66956112col_e
coled85540752coled
coles76055062coles
colic95726172colic
colin76231692colin
collop107312312collop
colly104926772colly
colobi105011082colobi
cologne1039352cologne
colone85425002colone
coloni85619202coloni
colons86028682colons
colony115417272colony
colors86622372colors
colour85915082colour
cols66553082col_s
colt67158242col_t
colts76633292colts
colugo935862colugo
coly96940532col_y
colza165112982colza
congo85623132congo
coo59566362co_o_
coof96643272co_of
cook107236932co_ok
cool66940492co_ol
cools75632632cools
cooly105525422cooly
coon67248942co_on
coop87238652co_op
coos67456492co_os
coot67860382co_ot
coplot10518272coplot
coydog1335132coydog
dolor67617962dolor
duolog835802duolog
ecology13218822ecology
flog85523892_flog
isolog737402isolog
kolo87026222kolo_
kolos94921212kolos
log46252682__log
nolo46229312nolo_
nolos54423352nolos
ology94113112_ology
oology103210252oology
oolong738072oolong
polo66236632polo_
polos76129912polos
prolog94212972prolog
slog56728272_slog
solo45538942solo_
solon55026132solon
solos54830792solos

Search took 4 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.1061685764.2
2DLD Change Limit53800932.98618017.4
3Display Results93930.0303100.0
 (SQL Overall)178691933.12257236.1
 
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.