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

293 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
colobi10501108(None) 
coloni85619201coloni
colby124415062col_by
colobus11389372colobus
colog86619932colo_g
cologs96517352cologs
colon78630192colo_n
colone85425002colone
colonic115015712colonic
colons86028682colons
colony115417272colony
color76123742colo_r
colors86622372colors
colossi935672colossi
colour85915092colour
alibi7514233_alibi
blob86027093_blob_
blobs95620033_blobs
boleti8413403boleti
bolo65535953bolo__
bolos75531373bolo_s
bonobo1037143bonobo
boob85932583bo_ob_
boobie104015293bo_obie
boobs96221993bo_obs
booby125319513bo_oby
cabob114616813cabob_
cabobs124311893cabobs
calami10313423calami
calo64936443calo__
caloric113413223caloric
calorie92716893calorie
calory11312843calory
calos74431903calo_s
carob95325223carob_
carobs104818103carobs
caroli85918233caroli
celeb9314873celeb_
celebs1037883celebs
celli76717693cel_li
celom9515683celo_m
celoms10412123celoms
celosia939463celosia
chloric143410613chloric
chlorid133211843chlorid
chlorin123113003chlorin
cholo105217973cholo__
cholos114716853cholo_s
clavi104912923c_lavi
cloak115214013c_loak
clock134917983c_lock
clod76124613c_lo_d
clods85320863c_lods
clog76123243c_lo_g
clogs85519553c_logs
clomb115714703c_lomb
clomp115615703c_lomp
clon66232483c_lo_n
clone75728163c_lone
clonic104914673c_lonic
clonk114417443c_lonk
clons75228133c_lons
cloot76127053c_loot
cloots85113693cloots
clop86929893c_lo_p
clops95924853c_lops
close76425223c_lose
clot66542423c_lo_t
cloth105817543c_loth
clots75627643c_lots
cloud86716423c_loud
clour76617283c_lour
clout75330463c_lout
clove105619443c_love
clown105214733c_lown
cloy96623833c_lo_y
cloys104916943c_loys
cloze165517543c_loze
club85819473c_lub_
clubs95415103c_lubs
coalbin1137533coalbin
coalbox1844113coalbox
coati75624643co_ati
cob710258753c__ob_
cobb106422003c__obb
cobbs115013993co_bbs
cobby145516413co_bby
cobia94117513c__obia
cobs87043143c__obs
cocci82812673co_cci
coco87330603coco__
cocoa98517883coco_a
cocoas104915743cocoas
cocoon10312263cocoon
cocos95624693coco_s
codon86522853codo_n
codons96119463codons
coelom10310423coelo_m
coelome1139683coelome
coelomic1445713coelomic
coeloms1139063coeloms
cogon89120903cogo_n
cogons96818113cogons
cohabit1449563cohabit
coho97524493coho__
cohog117813043coho_g
cohogs125810273cohogs
cohort1110720263cohort
cohos105921853coho_s
cohosh14517123cohosh
cohost115217213cohost
cojoin1539503cojoin
col59360353col___
cola66541393col__a
colas75436773col_as
colbys13407153colbys
cold77338773col__d
colder95121843colder
coldly12459953coldly
colds85726973col_ds
cole66956113col__e
colead94114643colead
coled85540753col_ed
coles76055063col_es
coleus86818273coleus
colic95726173col_ic
colicin11313743colicin
colics104219903colics
colies84837053colies
colin76231693col_in
colins85229043colins
colitic112916193colitic
colitis92617353colitis
collar83816173collar
collet84030363collet
collie83621993collie
colloid10312883colloid
collop107312313collop
collops112611753collops
colly104926773col_ly
coloboma1444353coloboma
cologne1039353cologne
colonel94213283colonel
colones96124433colones
colonial10411343colonial
colonics123711613colonics
colonies103620013colonies
colonise102514283colonise
colonist102617933colonist
colonize192312773colonize
colonus94413443colonus
colored10313473colored
colorer9312523colorer
coloring11414843coloring
colorism122112433colorism
colorist102818993colorist
colorize192314203colorize
colours95913443colours
cols66553083col__s
colt67158243col__t
colter84625093colter
colts76633293col_ts
colubrid1344413colubrid
colugo935863colugo
columbic1643443columbic
column1038103column
colure8314163colure
coly96940533col__y
colza165112983col_za
colzas174010513colzas
comb106632113co_mb_
combe116223543co_mbe
combo114519433co_mbo
combos125316613combos
combs116122963co_mbs
comorbid1545033comorbid
comose105016843comose
comous10816503comous
congii957363congii
conglobe1344153conglobe
coni65534803c__oni
conoid9818883conoid
coo59566363co_o__
cooch124916833co_och
cooed84534343co_oed
cooee74531023co_oee
cooer74831013co_oer
cooey105828223co_oey
coof96643273co_o_f
coofs105924713co_ofs
cook107236933co_o_k
cookie123716043co_okie
cooks115429143co_oks
cooky145321363co_oky
cool66940493co_o_l
cooled95224583cooled
cooler84824713cooler
coolie83821603coolie
coolly114811393coolly
cools75632633co_ols
coolth1139513coolth
cooly105525423co_oly
coomb115615703co_omb
coombe124110093coombe
coombs124210193coombs
coon67248943co_o_n
coons76737283co_ons
coop87238653co_o_p
coops96229643co_ops
coopt95929853co_opt
coos67456493co_o_s
coot67860383co_o_t
cootie84223093co_otie
coots75636843co_ots
coplot10518273coplo_t
coplots11511593coplots
copout10418783copout
corbie103618203co_rbie
corby125018533co_rby
cordoba1255743cordoba
corgi8316083co_rgi
corody12149703corody
corona83817403corona
couloir936153couloir
coulomb1344553coulomb
coulombic1752263coulombic
coulombs1443093coulombs
cowboy1637063cowboy
coyote11411783coyote
croci95818133c_roci
culti76317253cul_ti
dhobi1136973_dhobi
dolci84912603dol_ci
dolor67617963dolo_r
dolors75115313dolors
dolour75710133dolour
doobie94712683do_obie
ecologic1349563ecologic
ecology13218823ecology
glob76623393_glob_
globe84917013_globe
globin9309723_globin
globs85616403_globs
golosh1036463golosh
jojoba1441553jojoba
kilobit13126883kilobit
kolo87026223kolo__
kolos94921213kolo_s
lob57154463__lob_
lobe65535363__lobe
lobo67229863__lobo
lobs66441083__lobs
loci66126283__loci
logoi69715943logo_i
looby108115623lo_oby
loti46431843__loti
maloti8313213maloti
moloch1356483moloch
nolo46229313nolo__
nolos54423353nolo_s
nomoi76012533nomo_i
obi57127733___obi
oboli73712873_oboli
octopi1036533octopi
ology94113113_ology
oologic1049423oologic
oology103210253oology
oolong738073oolong
oribi7311093_oribi
ovoli8358283_ovoli
polo66236633polo__
polos76129913polo_s
polypi13458593polypi
poori74816233po_ori
pylori1147163pylori
slob66029423_slob_
slobs74419873_slobs
soldi65717203sol_di
solei55624343sol_ei
soli46637013sol__i
solidi73813153solidi
solo45538943solo__
soloed74515743soloed
solon55026133solo_n
solons65120023solons
solos54830793solo_s
somoni8310743somoni
teloi54217383telo_i
tholoi9339233tholo_i
topoi76018353topo_i
volost9412643volost
volti84915963vol_ti
zombi1838993zo_mbi

Search took 7 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.1401276364.3
2DLD Change Limit1127162936.23618075.0
3Display Results2932930.0903255.6
 (SQL Overall)1786912936.46627635.5
 
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.