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 “retia” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

107 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
retia5532611(None) 
redia65524481redia
retial64724991retial
retie55735301retie
retina65023381retina
aecia73819282aecia
beta66234132bet_a
betta74916842betta
ceria75125362ceria
cretic102816282cretic
cretin82917912cretin
entia5318202entia
eta35834192_et_a
etic66123952_etic
etna46415262_etna
feria85922712feria
feta76528902fet_a
fetial95716192fetial
fetid93715982fetid
geta56627442get_a
media84721712media
meta65932412met_a
metis75025902metis
ostia52315582ostia
petit74332652petit
raia46638382r_aia
raita54623072raita
ratio55227582ratio
realia6314592realia
reata54225392reata
rebid85121362rebid
recit75235102recit
recta74220262recta
recti73619622recti_
rediae74221992rediae
redial74923112redial
redias74523602redias
redid74922392redid
redip87816962redip
refit84230062refit
refix155212482refix
regina75317142regina
regma84612332regma
regna64614812regna
rei35647252re_i_
reif76937652re_if
rein46040892re_in
reis45343232re_is
rejig133810122rejig
relic74623362relic
relit55340682relit
remit75737222remit
remix145916552remix
renig64518912renig
renin54830032renin
reoil55321182reoil
repin75324702repin
rerig64018482rerig
resid64124092resid
resin54131052resin
resit54241042resit
ret35982832ret__
retag63618412retag
retail65522072retail
retain64523282retain
retax124517972retax
retch104818302retch
rete44944132ret_e
reteam83214532reteam
retear63115482retear
retem74221952retem
retiary1038332retiary
retied75924982retied
reties65436192reties
retile65929672retile
retime85321802retime
retinae75517332retinae
retinal75318352retinal
retinas74819352retinas
retine66237332retine
retint65633442retint
retire64927012retire
retral64419742retral
retrial7615552retrial
retrim83514882retrim
retro55020952retro
retry84718082retry
rets45352562ret_s
retsina74710602retsina
rewin85623962rewin
ria36745502r__ia
rota45834342rot_a
roti46332932roti_
rotis56327062rotis
rutin55421342rutin
sepia75318672sepia
seta45637312set_a
telia55821142telia
tenia55324482tenia
tetra53417952tetra
uredia73610062uredia
uremia82910892uremia
uretic82914352uretic
xenia124814772xenia
yeti75823212yeti_
yetis85418392yetis
zeta135121642zet_a

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538001071.50035866.7
3Display Results1071070.0303566.7
 (SQL Overall)1786911071.82697859.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.