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

144 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
amitoses103906(None) 
amitosis1047211amitosis
mitoses9312181_mitoses
abioses9311502abi_oses
acidoses1136772acidoses
adiposes1137172adiposes
amidases1136652amidases
amidones11348662amidones
amities9317382amit_ies
amitroles1144722amitroles
amyloses1347222amyloses
halitoses1246612halitoses
maltoses1039862maltoses
mioses84318852_mi_oses
mitises9315542_mitises
mitosis939632_mitosis
abatises10311023abatises
abiosis939383abi_osis
acetones10310033acetones
acetose938853acetose_
acidosis1146143acidosis
acinose938583acinose_
adenoses947903adenoses
adipose1036653adipose_
adiposis1146253adiposis
admittees1243273admittees
aftosas10147153a_ftosas
agaroses938823agaroses
agitates9310883agitates
aitches123014363a_itches
aldoses8311203a_ldoses
aliases7914493ali_ases
amarones10311353amarones
amasses93912853am_asses
amatols938183amato_ls
amauroses1144473amauroses
ambones11312683am_bones
amiantuses1292703amiantuses
amices105018013ami__ces
amidase1036733amidase_
amides95722663ami__des
amidines113010853amidines
amidogen1243913amidogen
amidogens1343653amidogens
amidols10457563amido_ls
amidone10349313amidone_
amies76837693ami___es
amigos94511213amigo__s
amines84727983ami__nes
amirates101114803amirates
amiss75823073ami__s_s
amitotic1247013amitotic
amitrole1045173amitrole_
amniotes1036603amniotes
amoles84122193am__oles
amortises1178823amortises
amuses85117943am__uses
amylases1346663amylases
amylose1237193amylose_
anatases839793anatases
anemoses10159433anemoses
animuses1037983animuses
anises64826703ani__ses
anisoles81010123anisoles
apodoses1136653apodoses
apoptoses1346443apoptoses
apposes11511473a_pposes
ariose64818733ari_ose_
ariosos7409863ari_osos
arises65233803ari__ses
arkoses113910833a_rkoses
athetoses1244983athetoses
atones65225773a__tones
axises134413993axi__ses
axites134913833axit__es
azotises1737603azotises
azygoses2163313azygoses
baritones1158953baritones
bigoses1039073_bigoses
camises114218463cami__ses
camisoles1345583camisoles
caritases1139763caritases
citoles9312553_citoles
coituses1039623coituses
epitases1038933epitases
epitomes1257713epitomes
epitopes1246973epitopes
halitosis1245203halitosis
halituses1245573halituses
hematoses1448463hematoses
heptoses1338373heptoses
imitates10310503imitates
imposes113213683im_poses
iritises839983iritises
ketoses114912873_ketoses
kurtoses12105623kurtoses
lactoses1039833lactoses
laminose1036913laminose_
litotes7311183_litotes
lotoses73713653_lotoses
maltases1039693maltases
maltose939793maltose_
mannoses1039083mannoses
mantises10317923mantises
meioses9310833_meioses
metopes11311363_metopes
mimeses1139073_mimeses
mimosas1136763_mimosas
minuses93512703_minuses
miosis83615163_mi_osis
mises74740563_mi__ses
misses85130873_mi_sses
misuses93216023_misuses
mites75141803_mit__es
mitogen1036963_mitogen
mitogens1146973_mitogens
mitres83922073_mit_res
mutases92012043_mutases
mycoses1437733_mycoses
myoses114013843_m_yoses
ostoses71213553_ostoses
otitises839163otitises
pentoses10312893pentoses
phimoses1537213phimoses
psiloses1036443psiloses
ptoses83514673__ptoses
riboses9310443_riboses
samites93118713samit__es
sanitises91111743sanitises
semioses10611013semi_oses
semitones1148943semitones
situses72710493_situses
smites83921923smit__es
smithies1337913smithies
tamises92715973tami__ses
trioses75015653tri_oses
triposes1039973triposes
tritones83413443tritones
vaginoses1344143vaginoses
vamooses1345523vam_ooses
vamoses1239153vam__oses
varicoses1446663varicoses
viroses10310533_viroses
vomituses1483903vomituses

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621447.40319743.6
3Display Results1441440.0632285.7
 (SQL Overall)1786911447.88922650.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.