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

127 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
titanic96855(None) 
tetanic9810131tetanic
titania738291titania
botanic1159582botanic
italic839902_italic
pianic103714122pi_anic
satanic939932satanic
tetanics10127372tetanics
titan53318172titan__
titanias847102titanias
titanism1048212titanism
titanite898432titanite
titanium1046032titanium
titans63414912titan_s
actinic111810553actinic
astatic9514193astatic
atavic11189293_atavic
ataxic15169203_ataxic
atonic83420473_atonic
bibasic1345643bibasic
bionic103614573bi_onic
botanica1295723botanica
citric102812313cit_ric
cyanic133110773_cyanic
diatonic1138673diatonic
dibasic1246033dibasic
ectatic11310123ectatic
eirenic939003eirenic
epitaxic1944283epitaxic
ethnic1148853_ethnic
gigantic1244303gigantic
gitano738043gitan_o
gitanos837173gitanos
iatric8312163_iatric
iconic10411593_iconic
ionic74622663_i_onic
irenic8311103_irenic
ironic8313773_ironic
italics936993_italics
ketonic1349923ketonic
limnic10418843li_mnic
litai55216363lita_i_
litanies8310993litanies
litany939053litan_y
lithic1139493lit_hic
litotic939243litotic
manic94629443__manic
melanic11310403melanic
mitotic1139713mitotic
nirvanic1342253nirvanic
nitric82512063nit_ric
oceanic1146163oceanic
octadic1245713octadic
organic1038313organic
otitic83112683otit__ic
panic93923903__panic
picnic123410263pi_cnic
pionic103515953pi_onic
piratic11314293piratic
potamic13310853potamic
puranic11410483puranic
puritanic1343583puritanic
sialic8313633si_alic
siganid947203siganid
stannic936663_stannic
static83118683_static
sultanic1046173sultanic
tabanid1047333tabanid
tannic82811473t_annic
tantalic1048053tantalic
tartaric1047053tartaric
tatami839193tatami_
tatamis939723tatamis
technic1496903technic
tectonic1248453tectonic
tetanal738023tetanal
tetanical1146533tetanical
tetanies8513553tetanies
tetanise8610203tetanise
tetanize17109953tetanize
tetanoid947203tetanoid
tetanus737933tetanus
tetany959843tetan_y
tetradic1145813tetradic
thionic1238893thionic
tictac1036563ticta__c
tilapia945553tilapia
timpani11266153timpani_
tisane6311573tisan_e
tisanes7311853tisanes
titanate897173titanate
titaness836723titaness
titanisms1147423titanisms
titanites997413titanites
titaniums1144763titaniums
titanous846553titanous
titbit839823tit_bit
tithing113513893tithing
tithonia1195613tithonia
titi47130623tit__i_
titian62512663titian__
titians72710453titian_s
titis56023813tit__is
titling83715793titling
titman82711003titman__
titmice1144663tit_mice
titrant7315193titran_t
titrants838483titrants
tittie63213153tit_tie
tonic74727653__tonic
totemic1137533totemic
tragic93811543t_ragic
triadic1037833triadic
tribadic1344103tribadic
tribasic1244793tribasic
tunic74018223__tunic
tympanic17234083tympanic
tyrannic1344143tyrannic
tyronic1239313tyronic
uranic82315183_uranic
viatic11311453vi_atic
vinic10314973vi__nic
vitamin1237423vitamin
vitaminic1642223vitaminic
vitric112510113vit_ric
witan83816503witan__
witans93412933witan_s

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.436409841.7
2DLD Change Limit1340271277.12618808.2
3Display Results1271270.0462760.9
 (SQL Overall)1786911277.60823487.3
 
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.