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

111 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
otitides93729(None) 
otitises839161otitises
coxitides1945112coxitides
osteitides1143962osteitides
otitis63612342otiti__s
ovicides1445462ovicides
actinides12188323actinides
altitudes10196583altitudes
amities9317383amiti_es
aptitudes12156183aptitudes
attires72312953at_tires
attitudes10155743attitudes
betides104915273_betides
cities84524853_citi_es
colitises11311743colitises
comities12317793comiti_es
cotinines11410073cotinines
cystitides1644063cystitides
deicides1249303deicides
deities82621923deiti_es
ditties83116983ditti_es
divides123211453_divides
entities8617413entiti_es
feticides1547003feticides
fortitudes1444063fortitudes
glottides1163833glot_tides
holytides1644743holytides
homicides1745853homicides
hotties103016963hot_ti_es
ileitides1045623ileitides
imides94515343__imides
irides74519123__irides
iritises839983iritises
kitties113213623kitti_es
laities7320343laiti_es
latitudes10185723latitudes
lipides103810623_lipides
mastitides1345833mastitides
miticides1447083miticides
mitises9315543_mitises
nitrides92910703nitrides
noontides1075133noontides
notifies11310423notifi_es
oddities1046603odditi_es
offsides1543393offsides
ofttimes1343123ofttimes
olivines1137473olivines
ootids71110353o_otid_s
opioids1036523opioid_s
optatives1445203optatives
optimes1148473o_ptimes
optimises1346083optimises
optimizes2245423optimizes
oreides8312023o_reides
orifices1346483orifices
oroides8311973o_roides
otitic83112683otiti__c
outchides1546793outchides
outcities1149513outciti_es
outguides1145413outguides
outpities1148623outpiti_es
outrides92414993outrides
outsides92513233outsides
outstrides1154753outstrides
ovaritides1443983ovaritides
ovicide1346433ovicide_
oxides14109693o__xides
oxidises1644833oxidises
oxidizes2544583oxidizes
ozonides1854293ozonides
peptides132610273peptides
pities83828083_piti_es
polities102722343politi_es
positives1459173positives
potties93723543pot_ti_es
proctitides1664723proctitides
raticides1248693raticides
riptides1136423riptides
solitudes10105013solitudes
statices102712343statices
statives112710793statives
stibines1038153stibines
stimies9316563stimi_es
stipites1039653stipites
stitches131410593stitches
stithies1139233stithies
strides84520393st_rides
suicides1139083suicides
tides64830153___tides
tidies74721833_tidi_es
tildes74513963_ti_ldes
timider1037093_timider
timidest1136933_timidest
tirades8311723_tirades
tithes94720213_tit_hes
titians72710453_titians
titis56023813_titi__s
titles63719923_tit_les
titres64718933_tit_res
titties73617363_titties
tittles73413253_tittles
toluides935553toluides
tontines82114733tontines
topsides1137203topsides
unities72520153uniti_es
unitizes1739133unitizes
utilises848973utilises
utilizes1758123utilizes
vaticides1546603vaticides
vomitives1744613vomitives
whities133113253whiti_es

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621117.94018408.3
3Display Results1111110.0761460.5
 (SQL Overall)1786911118.43621182.0
 
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.