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

103 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
titania73829(None) 
titanias847101titanias
titanic968551titanic
tetanic9810132tetanic
tilapia945552tilapia
titan53318172titan__
titanism1048212titanism
titanite898432titanite
titanium1046032titanium
titans63414912titan_s
tithonia1195612tithonia
actinia91710853actinia
apimania1245473apimania
astasia7310933astasia
ataxia13179593_ataxia
atonia63816513_atonia
biennia994933biennia
botanic1159583botanic
botanica1295723botanica
britannia1152243britannia
brittania1152483brittania
crania82418433_crania
entasia73110063entasia
estancia1044883estancia
filaria1039653filaria
gazania1746123gazania
gitano738043gitan_o
gitanos837173gitanos
himatia1248593himatia
inia45024703_i__nia
italic839903_italic
latakia1146093latakia
liana53915893li_an_a
litai55216363lita_i_
litanies8310993litanies
litany939053litan_y
lithia939333lit_hia
logania847833logania
mania75634153__mania
patagia1068783patagia
petunia966803petunia
pianic103714123pi_anic
pirana8713263piran_a
piranha12126363piranha
pitaya1186603pita_ya
ratafia1045773ratafia
satanic939933satanic
siganid947203siganid
stadia7312143_stadia
stanza1537073_stanza
tabanid1047333tabanid
taenia6313193t_aenia
tafia84215493__tafia
talaria7412523talaria
tanga64923693__tanga
tanka93817483__tanka
tartana73010193tartan_a
tatami839193tatami_
tatamis939723tatamis
tenia55324483__tenia
tetanal738023tetanal
tetanical1146533tetanical
tetanics10127373tetanics
tetanies8513553tetanies
tetanise8610203tetanise
tetanize17109953tetanize
tetanoid947203tetanoid
tetanus737933tetanus
tetany959843tetan_y
tiara5315913ti_a_ra
tibia7312403ti__bia
tilapias1045293tilapias
timpana11226133timpan_a
timpani11266153timpani_
tinea54923163ti__nea
tisane6311573tisan_e
tisanes7311853tisanes
titanate897173titanate
titaness836723titaness
titanisms1147423titanisms
titanites997413titanites
titaniums1144763titaniums
titanous846553titanous
titbit839823tit_bit
tithing113513893tithing
tithonias1285253tithonias
titi47130623tit__i_
titian62512663tit__ian
titians72710453titian_s
titis56023813tit__is
titling83715793titling
titman82711003titman__
titrant7315193titran_t
titrants838483titrants
tittie63213153tit_tie
triennia844563triennia
urania62516123_urania
vitamin1237423vitamin
vivaria1346983vivaria
wistaria1146623wistaria
witan83816503witan__
witans93412933witan_s
zinnia1536013zi_nnia

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 Limit1340271036.95319276.1
3Display Results1031030.0303433.3
 (SQL Overall)1786911037.38924183.4
 
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.