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

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
tarsi5522217(None) 
tars46763951tars_
tarsia65514271tarsia
torsi57423361torsi
ars37670932_ars_
arse46539272_arse
arsis55722422_arsis
bars66564092bars_
bassi77019322bassi
carpi94319392carpi
cars67364762cars_
carse74934332carse
ears46356592ears_
farci105919312farci
garni6315702garni
gars55750742gars_
harsh116418052harsh
jars117338352jars_
karst97228992karst
lari45839152lar_i
laris54737462laris
lars46956572lars_
lassi56316852lassi
mars66261872mars_
marse76231152marse
marsh105320852marsh
naris55735292naris
oars46846032oars_
pardi85723952pardi
paris75145942paris
pars67560792pars_
parse75236992parse
sari45444042sar_i
saris54544952saris
stars55836572stars_
tabs66842982tabs_
tads57143942tads_
tags55545232tags_
tahrs85412332tahrs_
tahsil936342tahsil
tali46837162ta_li
tamis76728732tamis
tams67247932tams_
tans46154822tans_
tansy84514932tansy
taos45541002taos_
tapis75028862tapis
taps66050672taps_
tar37570692tar__
tardo65321102tardo
tardy94720462tardy
tare45957622tar_e
tared69340052tared
tares57456562tares
targe65227092targe
tarn46842722tar_n
tarns56433952tarns
taro46846912tar_o
taroc75721642taroc
tarok97921072tarok
taros55640822taros
tarot55943932tarot
tarp66936412tar_p
tarps76527112tarps
tarre55825632tarre
tarry85422512tarry
tarsal63315272tarsal
tarsias74013372tarsias
tarsier74119252tarsier
tarsus6310512tarsus
tart47566182tar_t
tarts57242022tarts
tarty86328182tarty
tas38477102ta_s_
task85326652ta_sk
tass45640572ta_ss
tasse54821842tasse
tassie66017022tassie
tats46858132tats_
tatsoi637262tatsoi
taus46342732taus_
tavs75630972tavs_
taws75641592taws_
tawse85616502tawse
taxi117124762ta_xi
taxis126821972taxis
tears55436462tears_
terai53525482terai
terse55026822terse
thyrsi1234452thyrsi
tori47542152tor_i
torii55521592torii
tors46157382tors_
torse55833332torse
torsk94915772torsk
torso56922142torso
tragi64717172tragi
trash86119762trash
trass56226472trass
tsars56717112tsars_
tzars144914272tzars_
vars75742072vars_
wars78659802wars_

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.313570897.8
2DLD Change Limit538001031.43637465.2
3Display Results1031030.0333121.2
 (SQL Overall)1786911031.782100275.5
 
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.