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

189 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
coolant931646(None) 
coolants1039941coolants
callant94121222callant
cholent12313252cholent
colorant10414722colorant
coolest9318642coolest
cooling103422572cooling
courant9317972courant
volant9316322_volant
alant55742293__alant
aslant6317753_aslant
buoyant1246263buoyant
callan83619603callan_
callans94518473callans
callants104112143callants
cant66362023c___ant
chant105932693c__hant
choana1138443cho_ana
chola104718033chola__
cholas114817993chola_s
cholate122114933cholate
cholents1337623cholents
choline122915383choline
clamant11312433clamant
clan65633923c__lan_
clang86019313c__lang
clank114719523c__lank
clans75031013c__lans
clapt98027173c__lapt
clast76030583c__last
coact96130573c_o_act
coagent10313973coagent
coagulant1245173coagulant
coala77521123coala__
coalas87418963coala_s
coaling103722823coaling
coalpit1148503coalpit
coapt96131523c_o_apt
coast75236263c_o_ast
coat67558343c_o_a_t
cobalt10317393c_obalt
cocoanut1246903cocoanut
cocomat13413623cocoma_t
codlin94516433codlin_
codling114418953codling
codlins104116243codlins
coenact11311803coenact
cogent9321003c_ogent
coiling103723453coiling
cola66541393c_ola__
colas75436773c_ola_s
colin76231693c_olin_
colins85229043c_olins
collage102813753collage
collar83816173colla_r
collard103712923collard
collaret103116703collaret
collars93816573collars
collate92919683collate
collect113314593collect
collet84030363c_ollet
collins93419833collins
cologne1039353cologne
colon78630193c_olon_
colone85425003c_olone
coloni85619203c_oloni
colons86028683c_olons
colony115417273c_olony
colorants1149863colorants
colt67158243c_ol__t
combat12316753comba_t
command14399213command
comment1310317703comment
compact153712213compact
company1619711143company
compart134016003compart
complaint15410243complaint
compliant1549663compliant
concent114422513concent
condolent1249833condolent
conodont11411153conodont
consent93723113consent
consonant11410163consonant
constant10515593constant
contact1144020683contact
content94326153content
convent123919413convent
cooing94024923coo_ing
cooking143818973cooking
cookout13410143cookout
cool66940493cool___
cooled95224583cool_ed
cooler84824713cool_er
coolers93522493coolers
coolie83821603cool_ie
coolies93824963coolies
coolish12312523coolish
coolly114811393cool_ly
cools75632633cool__s
coolth1139513cool_th
coolths1236013coolths
cooly105525423cool__y
coon67248943coo__n_
cooncan1147233cooncan_
cooncans1246273cooncans
coons76737283coo__ns
cooping123918933cooping
coopt95929853coo__pt
coot67860383coo___t
coplanar1244473coplanar
coplot10518273copl_ot
coranto9311893c_oranto
corban10314693corban_
corbans11313173corbans
cormorant1348573cormorant
corposant1347093corposant
corybant1547573corybant
cosecant12410683cosecant
cotan71521783c_otan_
cotans81317923c_otans
cotenant10511793cotenant
couchant1549053couchant
couldst1037043couldst
count74932053c_o_unt
courante1049953courante
couranto1046903couranto
courants10310803courants
courlan9117763courlan_
courlans10117613courlans
covalent1349223covalent
covenant1349693covenant
cowbane1437673cowbane
cowhand1665933cowhand
cowling134017413cowling
cowman13910373cowman_
cowpat13312033cowpa_t
cropland1346303cropland
currant9314173currant
dopant9316133_dopant
dormant102814373dormant
explant16310133explant
fondant11311143fondant
fooling113117373fooling
formant123416003formant
gallant83517113gallant
gelant72821673_gelant
gellant83214053gellant
holland11349473holland
implant11311333implant
lowland1134693lowland
moola75117033moola__
moolah11409193moola_h
moolahs12347383moolahs
moolas83615593moola_s
moorland1144683moorland
mordant10312403mordant
norland837163norland
oblast8613663_oblast
octant81216553_octant
odorant8411393odorant
oolong738073_oolong
plant75437113__plant
poblano1145093poblano
pooling103219093pooling
prolan8414693prolan_
prolans9314273prolans
replant93318533replant
roborant1048383roborant
sealant73118303sealant
slant55238703__slant
solan55328153_solan_
soland75115043_soland
solano65314183_solano
solans64122493_solans
sonant6621953_sonant
sonorant8411703sonorant
tolan55124013_tolan_
tolane64316583_tolane
tolans64319273_tolans
tooling82918313tooling
troland837543troland
ululant747693ululant
violent102110813violent
volante1038513_volante
woodland1344603woodland
woolen93111373woolen_
woolens10398843woolens
woolhat1346043woolhat
woolman1235433woolman_

Search took 9 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271898.14016465.2
3Display Results1891890.1261500.0
 (SQL Overall)1786911898.42221217.2
 
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.