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

138 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
comitia113972(None) 
comitial1248691comitial
camisia112810242camisia
colitic112916192colitic
colitis92617352colitis
comatic131816942comatic
comatik15139722comatik
cometic131215722cometic
comities12317792comities
comity13312712comit_y
conidia1069302conidia
coxitis16238462coxitis
cymatia1446442cymatia
somitic111512632somitic
aconitic1239533aconitic
bolivia1246063bolivia
bonita8312943bonit_a
cambia124913153cam_bia
camelia11510443camelia
camisa103114323cami_sa
camisias12268603camisias
capita102913773capit_a
casita82913703casit_a
chitin113114963c_hitin
cilia73016763c__ilia
clitic103315053c_litic
clivia1177233c_livia
coati75624643co_ati_
coatis85122603co_atis
cobia94117513co__bia
coccidia1244013coccidia
codeia94112193co_deia
codicil1246813codicil
cogito939203cogit_o
cogitos1037613cogitos
coital84117053co_ital
coition9314313co_ition
coitus8511893co_itus
colicin11313743colicin
colistin10410553colistin
colpitis1247503colpitis
coma87134853com___a
comate104124843comat_e
comates114123643comates
comatiks16148043comatiks
comatula1244263comatula
comedian1347453comedian
comedic14158633comedic
comet95946073comet__
cometh134811683comet_h
comets105823583comet_s
comfit133112423com_fit
comfits14328743comfit_s
comic114721813com__ic
comical13312223comical
comics124015563comi_cs
coming114225453comi_ng
comings124013533comings
comix163513203com__ix
comma114514793com__ma
commata1338483commata
commie124215523com_mie
commit124016703com_mit
commits133812383commit_s
committal1543723committal
commix19407763com_mix
complin13312073complin
compt116328223compt__
compted143813523compted
compting153013603compting
compts125216653compt_s
comte96125473com_t_e
comtes106222813com_tes
conidial1159503conidial
conidian1168383conidian
contra83314703co_ntra
coontie9311423coontie
cootie84223093co_otie
coremia11310363coremia
coria75828323co__ria
cortin82423153co_rtin
cortina91915973cortina
cosmetic1447783cosmetic
costa75523733co_st_a
cotinga10348023cotinga
cotta75818573co__tta
countian1048123countian
critic103616813c_ritic
cubiti10399083cubiti_
cumbia12379893cum_bia
cymbidia1842083cymbidia
domicil1246433domicil
dominie103111643dominie
fomite113314073fomit_e
fomites123613203fomites
godetia945353godetia
gomuti936553gomuti_
gomutis1035733gomutis
gonidia975903gonidia
himatia1248593himatia
hominian1357093hominian
hominid13249533hominid
hospitia1344003hospitia
komatik12135203komatik
milia72719573__milia
militia949733militia
mitis75425993__mitis
nomina83113683nomi_na
nomistic1279593nomistic
noritic91213543noritic
oidia6314953_o_idia
omit65337373_omit__
omits75018263_omit_s
oolitic92512883oolitic
ostia52315583_o_stia
otitic83112683_otitic
otitis63612343_otitis
poditic122611583poditic
politic112918713politic
scotia8310803sco__tia
solatia7312253solatia
somata8312383somat_a
somatic111916473somatic
somital939403somital
somite84519373somit_e
somites94219123somites
soritic91414433soritic
tomtit8413853tom_tit
vomica1336383vomi_ca
vomit102622573vomit__
vomited1337253vomited
vomiter1237953vomiter
vomiting1437733vomiting
vomitive1645853vomitive
vomito11238033vomit_o
vomitos12217103vomitos
vomits112610923vomit_s
vomitus12215743vomitus

Search took 8 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.406440125.6
2DLD Change Limit1340271387.03319056.9
3Display Results1381380.0463000.0
 (SQL Overall)1786911387.48523873.2
 
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.