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

162 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
retie5573530(None) 
rete44944131ret_e
retia55326111retia
retied75924981retied
reties65436191reties
retile65929671retile
retime85321801retime
retine66237331retine
retire64927011retire
aerie54634602aerie
arete56031352aret_e
belie75630382belie
betide95115972betide
betime105914832betime
betise85616272betise
cete64934782cet_e
cretic102816282cretic
cretin82917912cretin
cutie76925922cutie
dexie134716892dexie
eerie55228532eerie
etic66123952_etic
fete75734922fet_e
fetid93715982fetid
genie66124922genie
jete115927252jet_e
lethe85717302lethe
mete64438132met_e
metier83517692metier
metis75025902metis
metre74821302metre
newie81813482newie
petit74332652petit
petite84320652petite
premie103617992premie
ramie75027822ramie
rate45458762rat_e
rathe85821922rathe
ratine65131822ratine
ratio55227582ratio
ratite65022422ratite
reave84528022reave
rebbe9313152rebbe
rebid85121352rebid
recce9514562recce
recipe103414892recipe
recit75235102recit
recite83625112recite
recti73619622recti_
rede55037662re_de
redia65524482redia
rediae74221992rediae
redid74922392redid
redip87816962redip
redye94413462redye
ree37974072re__e
reeve84121322reeve
refile95122372refile
refine95225692refine
refire95419472refire
refit84230062refit
refix155212482refix
regime95313942regime
regive104814322regive
rehire95415862rehire
rei35647252re_i_
reif76937642re_if
rein46040892re_in
reis45343232re_is
reive85522942reive
rejig133810122rejig
relic74623362relic
relied74926232relied
relief94419672relief
relier65826182relier
relies65036422relies
reline65434352reline
relit55340682relit
relive95120782relive
remise84221952remise
remit75737222remit
remix145916552remix
renig64518912renig
renin54830032renin
rente54733782rente
rentier73618222rentier
reoil55321182reoil
repin75324702repin
repine85627812repine
reptile93914082reptile
rerig64018482rerig
rerise64325632rerise
resee54336332resee
resid64124092resid
reside74224932reside
resile64627672resile
resin54131052resin
resit54241042resit
resite64128452resite
resize154117722resize
restive10315932restive
ret35982832ret__
retag63618412retag
retail65522072retail
retain64523282retain
retake104718532retake
retape83917682retape
retax124517972retax
retch104818302retch
retem74221952retem
retene69224272retene
retial64724992retial
reticle94112622reticle
retiled84420512retiled
retiles74426992retiles
retimed104714652retimed
retimes95020172retimes
retina65023382retina
retinae75517332retinae
retines75134672retines
retint65633442retint
retinue75414842retinue
retired84620142retired
retiree75019082retiree
retirer74715012retirer
retires74726212retires
retitle73913092retitle
retore67630762retore
retried84419152retried
retries74129072retries
retrim83514872retrim
retro55020952retro
retry84718082retry
rets45352562ret_s
retted74826312retted
retune69121952retune
retuse66617222retuse
retype11399142retype
reuse56025362reuse
review1238692review
revile94921612revile
revise94019742revise
revive124914822revive
revue81114452revue
rewin85623962rewin
rewire95421402rewire
rexine134719442rexine
rite45849452rit_e
rote46249022rot_e
roti46332922roti_
rotis56327052rotis
rotte54625932rotte
rutile65217682rutile
rutin55421342rutin
setae56026222setae
tentie62521182tentie
tie36557532__tie
untie54425492untie
uretic82914352uretic
vegie94614512vegie
yeti75823212yeti_
yetis85418392yetis

Search took 5 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.186960704.3
2DLD Change Limit538001623.75014346.7
3Display Results1621620.0931741.9
 (SQL Overall)1786911624.02944351.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.