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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 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
turistas84669(None) 
touristas943371touristas
turista737441turista_
aristas7413522_aristas
aurists74615782aurist_s
baristas1039722baristas
jurists14409122jurist_s
purists94014072purist_s
tourista844402tourista_
tourists838312tourist_s
tubists9288322tubist_s
amritas939093amri_tas
aorists74215833aorist_s
arista6415293_arista_
aristae7312533_aristae
aristos7312373_aristos
aubrietas1142833aubrietas
aurist65027253aurist__
autists73814853autist_s
barista9310813barista_
bursas85318273bur_s_as
bursitis1045033bursitis
bursts85116243bur_st_s
caritas93316953cari_tas
crista8311803_crista_
cristae9310613_cristae
cubists11359023cubist_s
cuestas957933cu_estas
curites93919863curi_tes
futurists1245583futurist_s
grists74716483_grist_s
harissas1145983harissas
hursts97213093hur_st_s
jurist134616393jurist__
juristic1746133juristic
kurtas10349883kur__tas
lutists73810273lutist_s
lyrists1036963lyrist_s
muriates10312083muriates
naturists947513naturist_s
nudists8356833nudist_s
orishas1036473_orishas
purisms114110833puris_ms
purist85525053purist__
puristic1239383puristic
puritan939283puri_tan
puritans1037633puri_tans
querists1736543querist_s
quintas163611713qu_intas
riatas63915093__riatas
ristras7311563__ristras
tanists7313653tanist_s
tarantas839193tarantas
tarsias74013373tar_sias
theists1039153theist_s
thirsts1036243thirst_s
thrifts1335523thrift_s
thrusts10226523thrust_s
tortas64918253tor__tas
tourisms1037613touris_ms
tourist7313203tourist__
touristed1044303touristed
touristic1145633touristic
touristy1144513tourist_y
triptan947543t_riptan
triptans1047363t_riptans
trishaw1344753t_rishaw
trishaws1444003t_rishaws
trismus935563t_rismus
tristate8311033t_ristate
triste63818643t_rist_e
tristezas1842743t_ristezas
truisms9106823truis_ms
truistic1046903truistic
trusts64714433t_rust_s
trystes10419993t_rystes
trysts9448793t_ryst_s
tsarists857303tsarist_s
tubaists1055103tubaist_s
tubist83013163tubist__
turbeths1373353turbeths
turbiths1374083turbiths
turbits969233turbit_s
turbots988023turbot_s
turfskis1541773turfskis
turgites937783turgites
turions7311573turi_ons
turpeths1373153turpeths
turrets73010673turret_s
twists9549753t_wist_s
typists1236173typist_s
tzarists1755693tzarist_s
verists103613673verist_s
veritas103012753veri_tas
vistas94513273__vistas
wrists95415643_wrist_s
wursts95211163wur_st_s

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162977.20320291.8
3Display Results97970.0332939.4
 (SQL Overall)178691977.39224173.6
 
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.