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

152 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
tinea5492315(None) 
tine45855131tine_
tineal66216151tineal
tineas64616471tineas
tined65434531tined
tines54848421tines
apnea73413412apnea
bine66650862bine_
biner75930692biner
bines76946792bines
cine66242942cine_
cinema1047642cinema
cines75239682cines
dine55555332dine_
dined76431992dined
diner65632902diner
dines66449152dines
finca104714502finca
fine75147952fine_
fined94930502fined
finer85431562finer
fines86644262fines
guinea737612guinea
idea59122772_idea
ilea45931462_ilea
inia45024702_inia
kina85631992kin_a
kine85643422kine_
kinema1236012kinema
kines95039132kines
line46965572line_
lineal65616022lineal
linear65113342linear
lined64934642lined
linen55728722linen
liner55938922liner
lines57054572lines
liney87029632liney
linga66820812linga
mina65136912min_a
minae75627722minae
mine67256162mine_
mined85333352mined
miner76933542miner
mines75651952mines
nine45842172nine_
nines55937342nines
ninja1258092ninja
pilea75123952pilea
pina65842632pin_a
pine67755712pine_
pineal84817682pineal
pined85935322pined
pines76048862pines
pineta85815562pineta
piney105727502piney
pinna75320182pinna
pinta75727052pinta
sine46560622sine_
sines55954822sines
sinew84718922sinew
tanga64923682tanga
tanka93817482tanka
tea37353322t__ea
tenet55542212tenet
tenia55324482tenia
thine85026852thine_
tiara5315902tiara
tibia7312402tibia
tide55237372tide_
tided76322512tided
tides64830152tides
tie36557532ti_e_
tied55535212ti_ed
tier44936142ti_er
ties45248312ti_es
tiger65718632tiger
tike85534482tike_
tikes95628902tikes
tikka835572tikka
tile45451442tile_
tiled64832942tiled
tiler56131022tiler
tiles55542102tiles
time66235012time_
timed85223612timed
timer75626042timer
times75630822times
tin36362172tin__
tincal83913352tincal
tinct76126232tinct
tinder73821802tinder
tineid74412012tineid
ting56139892tin_g
tinge64626612tinge
tinged84220792tinged
tinges74722322tinges
tings65329192tings
tinier63622232tinier
tinker103619922tinker
tinman82411122tinman
tinmen82310392tinmen
tinned74317532tinned
tinner64119962tinner
tinny85317652tinny
tins45251302tin_s
tinsel639442tinsel
tint46758862tin_t
tinted74419532tinted
tinter63923642tinter
tints56030922tints
tiny76134632tin_y
tire46143352tire_
tired65228902tired
tires55437492tires
titer55430612titer
toea46732332t_oea
tone46953742tone_
toned65435342toned
toner55336242toner
tones56048662tones
toney86027412toney
tonga65619682tonga
trine54734602trine_
trined74920712trined
trines64132562trines
tuna45127842tun_a
tune45635862tune_
tuned64622312tuned
tuner56022682tuner
tunes55332192tunes
twine85822362twine_
twined104413122twined
twiner94012592twiner
twines94717272twines
tyne76325052tyne_
tyned95915012tyned
tynes85920302tynes
usnea539392usnea
vina76331802vin_a
vinca105315162vinca
vine75643682vine_
vineal94814742vineal
vined95626152vined
vines85137642vines
wine74953422wine_
wined94434182wined
wines85546862wines
winey115325432winey
zine137036152zine_
zineb165614142zineb
zines145232652zines

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.0931921408.6
2DLD Change Limit538001521.76630464.3
3Display Results1521520.0463304.3
 (SQL Overall)1786911521.90593801.0
 
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.