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

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

209 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
tourism93942(None) 
tourisms1037611tourisms
tourist7313201tourist
houris94514582houris_
nourish1039702nourish
ogrism937912_ogrism
porism104518062po_rism
purism104715062_purism
sourish10310692sourish
touring82915192touring
tourista844402tourista
tourists838312tourists
touristy1144512touristy
tours55325892tour_s_
truism8118622tru_ism
tsarism958252tsarism
tsouris735152tsouris_
tsuris62710202tsuris_
tzarism1866322tzarism
tzuris15286912tzuris_
aneurism1046643aneurism
aorist64827873ao_rist
atomism112610963ato_mism
auris55331533_auris_
aurist65027253_aurist
auteurism1144613auteurism
autism83815333_autism
boarish123911913boarish
bogyism1545213bogyism
bohrium1475013bohrium
boorish123712593boorish
bossism1136063bossism
botulism1246473botulism
bourgs9459993bourgs_
bourns84114063bourns_
bourse84414333bour_se
boursin938283boursin
boyarism1546393boyarism
brutism1146773brutism
bruxism1843653bruxism
charism14712203charism
chrism13710673_chrism
colorism122112433colorism
corium10315723co_rium
cosmism1337013cosmism
coulis84018763coulis_
courier93617893courier
course85117783cour_se
courts84216173courts_
cubism12348703_cubism
curium10312503_curium
czarism2056423czarism
dodoism1135893dodoism
douras75016723douras_
dourest8312943dourest
dourine8311453dourine
ecotourism1452533ecotourism
eonism83213533eo_nism
fauvism1545223fauvism
flourish1446753flourish
fogyism1643943fogyism
fours85521493four_s_
futurism1345443futurism
gourds8108253gourds_
hoboism1446623hoboism
holism113713753ho_lism
houri85915253houri__
hours85422393hour_s_
iodism93611133io_dism
jurist134616393_jurist
kauris103611533kauris_
koumis1237623koumis_
koumiss1344313koumiss
kouros1039183kouros_
locoism1156793locoism
lookism1335913lookism
loris55329153lo_ris_
loudish1137983loudish
louis57322323lou_is_
louring83916503louring
lours55125293lour_s_
loutish1039963loutish
lyrism1137473_lyrism
mobbism1535053mobbism
momism93410353mo_mism
monism104016313mo_nism
moorish123311783moorish
morris83814733morris_
mourns84111013mourns_
mutism103211463_mutism
naturism1047893naturism
noirish1037883noirish
nomism103010953no_mism
noris54928273no_ris_
nudism9357913_nudism
obiism1036363_obiism
ogreism1044233_ogreism
ogrish1039263_ogrish
ogrisms1036443_ogrisms
orris54516553_orris_
ourie54027303_ouri_e
ours47237563_our_s_
pooris83916843pooris_
poorish123712303poorish
populism1446073populism
porisms113713453po_risms
pouring103115863pouring
pours74623183pour_s_
prism94820263__prism
puris75332023_puris_
purisms114110833_purisms
purist85525053_purist
slumism1136513slumism
solarism10810383solarism
sophism1437873sophism
souaris7312333souaris_
soubise9118793soubise
sourest7515713sourest
souring83219063souring
sours55230503sour_s_
stoicism1246873stoicism
stoures74614163stoures_
stourie7469353stouri_e
stours65015633stour_s_
stoutish1145903stoutish
tachism1478873tachism
tantrism1048373tantrism
taurine7311363taurine
tetris62816293tetris_
theism1139483t_heism
thorium12208413thorium
thulium1254473thulium
thurls9418713thurls_
tigrish1137573tigrish
toadish1139063toadish
toadyism1443673toadyism
tokenism1445403tokenism
tonish93415903to_nish
tonnish10149093tonnish
topis76025833to_pis_
toras55540373to_ras_
torcs75123763to_rcs_
tores55352673to_res_
tori47542153to_ri__
toric76529313to_ri_c
torics85118353to_rics
tories65435883to_ries
torii55521593to_ri_i
toros54336193to_ros_
torose64317693to_rose
torrid7311853torri_d
torrify1335013torrify
torrs53923563to_rrs_
tors46157383to_r_s_
torse55833333to_r_se
torsi57423363to_r_si
torsk94915773to_r_sk
torso56922143to_r_so
torts56138123to_rts_
torus54329763to_rus_
totalism10311093totalism
totemism1245433totemism
toughish1545283toughish
toughs105414983toughs_
tour45530383tour___
touraco945363touraco
toured74216153tour_ed
tourer64115073tour_er
tourers73512743tourers
tourings9277373tourings
touristas943373touristas
touristed1044303touristed
touristic1145633touristic
tourney1036273tourney
touse55430673tou__se
touses64229673touses_
tousing82916993tousing
touting84118453touting
touts54830393tou_ts_
tovarish1445123tovarish
townish13167933townish
toyish122911123to_yish
trim65329523t__ri_m
trims75021473t__rims
troilism1047193troilism
tropism1139293tropism
truisms9106823tru_isms
tsarisms1056653tsarisms
tsarist7712253tsarist
tsooris734693tsooris_
tsoris63411193tsoris_
tsorriss842683tsorriss
tubist83013163t_ubist
tuis44829643t_u_is_
turds65021693t_urds_
turfs84620443t_urfs_
turion6313163t_urion
turista737443t_urista
turks95320823t_urks_
turns55623243t_urns_
turps74918733t_urps_
tzarisms1965213tzarisms
tzarist1659103tzarist
utopism1146333uto_pism
verism113214263_verism
voyeurism1751983voyeurism
yours85217883your_s_
zoarium1846093zoarium
zoris145320013zo_ris_

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 Filter1786911340270.436409841.7
2DLD Change Limit1340272096.48320673.6
3Display Results2092090.0633317.5
 (SQL Overall)1786912096.98225593.1
 
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.