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

169 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
celotex163502(None) 
celotexes1843612celotexes
cenote83715842cenote_
cenotes92814542cenotes
belated103520013belated
beloved13188393beloved
belted94020633bel_ted
belter84720963bel_ter
calomel1138073calomel
calotte9510563calotte
calottes10610083calottes
caloyer1238143caloyer
capote10315733capote_
capotes11314643capotes
celeb9314873cel__eb
celeste949653celeste_
celestes10310013celestes
cellae84915933cellae_
celled94420323cel_led
celom9515683celo__m
celoms10412123celo_ms
celosia939463celosia
celt65646713cel_t__
celts75325783cel_t_s
center84421413ce_nter
cerate84829463cerate_
cerated103922473cerated
cerates95428233cerates
cerite84724873cerite_
cerites94823433cerites
cerotic11415053cerotic
certes84623083ce_rtes
cete64934783ce__te_
cetes75731103ce__tes
chelate122914893chelate_
chelated142610483chelated
chelates132713833chelates
cleated103417843cleated
clefted13326753clefted
cleome1039083cleome_
cleomes1138813cleomes
clone75728163c_lone_
cloned94518803c_loned
cloner84418093c_loner
clones84526563c_lones
close76425223c_lose_
closed95317963c_losed
closer84918203c_loser
closes85425593c_loses
closet85226603c_loset
clot66542423c_lot__
cloth105817543c_lot_h
clothe114712993c_lothe
clothed134010283c_lothed
clothes124513813c_lothes
cloths115512483c_loths
clots75627643c_lot_s
clotted104011823c_lotted
clotty11208263c_lotty
clouted104212163c_louted
clouter93511683c_louter
clove105619443c_love_
cloven114211513c_loven
clover114617123c_lover
cloves114918823c_loves
cloyed125111563c_loyed
cloze165517543c_loze_
clozes174915563c_lozes
codex155817573c__odex
coelome1139683coelome_
coelomes1239293coelomes
colone85425003colone_
colonel94213283colonel
colones96124433colones
colored10313473colored
colorer9312523colorer
colter84625093col_ter
cooter85128613c_ooter
cortex15311463c_ortex
cote66648733c__ote_
coted85033853c__oted
cotes76347843c__otes
coyote11411783coyote_
coyotes12410703coyotes
culex144613933cul__ex
culotte976893culotte
culottes1076293culottes
delate73827753delate_
delated93722873delated
delates83526283delates
delete73620703delete_
deleted93314903deleted
deletes83117933deletes
demote94817803demote_
demoted114313543demoted
demotes104717673demotes
denote74118043denote_
denoted93512763denoted
denotes83817003denotes
devote104513783devote_
devoted124111093devoted
devotee113811823devotee
devotes113713753devotes
elate55335883_elate_
elated74725823_elated
elater64724203_elater
elates65032363_elates
elite56230183_elite_
elites66027123_elites
elodea738673_elodea
elope75219343_elope_
eloped95914143_eloped
eloper85414153_eloper
elopes85918163_elopes
elute54822573_elute_
eluted74915263_eluted
elutes64020313_elutes
emote75421193_emote_
emoted94614923_emoted
emoter85415193_emoter
emotes84620283_emotes
felted103714653fel_ted
gelate73421253gelate_
gelated93615633gelated
gelates83219583gelates
gemote94613023gemote_
gemotes103712143gemotes
helot85332683helot__
helotry1345653helotry
helots95217703helot_s
kelter103214373kel_ter
latex124717113__latex
melted94219063mel_ted
melter83520113mel_ter
ocelot8813383ocelot__
ocelots977233ocelot_s
pelite84323003pelite_
pelites93821993pelites
pelota8612833pelot_a
pelotas9410723pelotas
peloton938743peloton
pelted94617753pel_ted
pelter83321623pel_ter
peyote1139853peyote_
peyotes1238483peyotes
piloted10310323piloted
relate64033633relate_
related83327573related
relater73723143relater
relates73731423relates
remote84222603remote_
remoter94815973remoter
remotes94521613remotes
revote94917453revote_
revoted114314153revoted
revotes104716393revotes
teletext1545253teletext
telex125214823tel__ex
telome8311923telome_
telomes9310533telomes
velate93720143velate_
velites103417303velites
veloce11310133veloce_
veloute1037733veloute_
veloutes1136153veloutes
vertex1637373ve_rtex
welted103715823wel_ted
welter93417383wel_ter
zlote143912943_zlote_

Search took 10 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.1701051123.5
2DLD Change Limit1340271699.30014411.5
3Display Results1691690.0463673.9
 (SQL Overall)1786911699.51618778.0
 
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.