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

206 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
colugo93586(None) 
colugos1035691colugos
clough12539132clough
colog86619932colog_
cologs96517352cologs
column1038102column
colure8314162colure
congo85623132co_ngo
cough115819642co_ugh
aerugo735803aerugo
beluga936233beluga
bolero8412093bolero
bolo65535953bol__o
bolus79125543bolu_s
bongo85720943bo_ngo
bough115719313bo_ugh
calico103414433calico
calo64936443cal__o
cargo85322073c_argo
cello74919583cel_lo
cholo105217973chol__o
chough15699243chough
chug105914113c_hug_
chugs115511943c_hugs
clag75924573c_lag_
clags85621123c_lags
claro75018693c_laro
clog76123243c_log_
cloggy1344873cloggy
clogs85519553c_logs
cloud86716423clou_d
clouds94612353clouds
cloudy12517803cloudy
cloughs13517053cloughs
clour76617283clou_r
clours85215093clours
clout75330463clou_t
clouts87017203clouts
club85819473c_lu_b
clubs95415103c_lubs
cluck134914893c_luck
clue65324533c_lu_e
clued84917683c_lued
clues74623033c_lues
clump115517453c_lump
clung86013603c_lung
clunk114215083c_lunk
coco87330603co__co
cog69552903co__g_
cogito939203cogito
cogon89120903co__gon
cogs77340033co__gs
coho97524493co__ho
cohog117813043cohog_
cohogs125810273cohogs
cohune1189423cohune
coign85013913co_ign
col59360353col___
cola66541393col__a
colas75436773col_as
colby124415063col_by
colbys13407153colbys
cold77338773col__d
colder95121843colder
coldly12459953coldly
colds85726973col_ds
cole66956113col__e
colead94114643colead
coled85540753col_ed
coles76055063col_es
coleus86818273coleus
colic95726173col_ic
colics104219903colics
colies84837053colies
colin76231693col_in
colins85229043colins
collage102813753collage
collar83816173collar
college102410433college
collet84030363collet
collie83621993collie
collop107312313collop
collude10337983collude
colly104926773col_ly
colobi105011083colobi
cologne1039353cologne
colon78630193col_on
colone85425003colone
coloni85619203coloni
colons86028683colons
colony115417273colony
color76123743col_or
colors86622373colors
colour85915093colour
colours95913443colours
cols66553083col__s
colt67158243col__t
colter84625093colter
colts76633293col_ts
columel1136273columel
columns1136473columns
colures9315143colures
coly96940533col__y
colza165112983col_za
colzas174010513colzas
combo114519433co_mbo
comedo11359603comedo
compo115318573co_mpo
concho134414263concho
condo85322593co_ndo
conga85419873co_nga
conge85227593co_nge
congos94219883co_ngos
congou94313243co_ngou
conto76027173co_nto
conus76726533conu_s
coo59566363co___o
coocoo1069693coocoo
copula102812043copula
coquet174318013coquet
coquito1845403coquito
corgi8316083co_rgi
cornuto937033cornuto
cosign958783cosign
couch125320113co_uch
coude85022633co_ude
cougar958783co_ugar
coughs125514543co_ughs
could86517713co_uld
coulee8323503coulee
coulis84018763coulis
count74932053co_unt
coup86729793co_u_p
coupe96023483co_upe
coupon102810993co_upon
coups95522473co_ups
court75532773co_urt
couth106122493co_uth
cowage12310663cowage
coydog1335133coydog
deluge8189403deluge
doggo84410703do_ggo
dough105217383do_ugh
ecology13218823ecology
erugo6369853_erugo
folio83820883fol_io
forego1038903forego
forgo94418333fo_rgo
galago838903galago
glug66118013_glug_
glugs75214283_glugs
gogo69722833go__go
gouge78220063go_uge
hollo84822163hol_lo
holloo94415253holloo
kluge104910453_kluge
kolo87026223kol__o
lanugo735573lanugo
logo57931763__logo
lough95118483lo_ugh
lug46138063__lug_
luge55531643__luge
lugs55233523__lugs
modulo9256983modulo
molto75619603mol_to
mongo810122413mo_ngo
nolo46229313nol__o
nonego737013nonego
oleo46630483_ol_eo
olingo736933_olingo
olio46829673_ol_io
ology94113113_ology
oology103210253oology
outgo6312093_outgo
ouzo133516933_o_uzo
plough12577563plough
plug74915993_plug_
plugs85213493_plugs
polio75722553pol_io
polo66236633pol__o
polygon1346933polygon
rouge65423443ro_uge
rough97819433ro_ugh
slough10539233slough
slug55124643_slug_
slugs64618563_slugs
solano65314183solano
soldo67116563sol_do
solo45538943sol__o
solum74717613solu_m
solums85211333solums
solus54726983solu_s
solute64016663solute
sorgo64719723so_rgo
sough95320463so_ugh
toledo7419993toledo
tolu45529153tolu__
toluic837693toluic
toluid738213toluid
toluol636903toluol
tolus55024483tolu_s
toluyl933443toluyl
tough97321983to_ugh
volume11358273volume
volute93912763volute
vulgo936953vul_go

Search took 6 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 Filter1786911127160.1231452772.4
2DLD Change Limit1127162065.72019705.6
3Display Results2062060.0633269.8
 (SQL Overall)1786912065.90630255.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.