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

138 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
tigrish113757(None) 
tigerish1246561tigerish
biggish14247502biggish
jiggish19225942jiggish
ogrish1039262_ogrish
pigfish16217172pigfish
piggish14227702piggish
tigress836092tigress
vigorish1545172vigorish
aguish1059283_aguish
anguish11117633anguish
bearish123013273bearish
boarish123911913boarish
boggish14238653boggish
boorish123712593boorish
cherish15310463cherish
currish1238353currish
diarist8517113diarist
digraph14146643digraph
digress938323digress
dogfish15226763dogfish
doggish13237533doggish
english1137953english
etherish1448273etherish
fairish1338993fairish
finfish16268193finfish
finish124613413fi_nish
fogyish1735363fogyish
garish104516923_garish
girlish1137193girlish
girsh95310023gi_r_sh
grigris934093grigris_
grist65529873__grist
grith95520373__grith
hagfish17227613hagfish
haggish15207473haggish
hickish1936473hickish
highrise1554403highrise
hippish1736183hippish
hogfish17257023hogfish
hoggish15247593hoggish
impish13499193_impish
inrush936513_inrush
iris45732553_i_ris_
jingoish19134383jingoish
kiddish16276583kiddish
kingfish1944493kingfish
largish1138603largish
lightish1556623lightish
liverish1447863liverish
loggish12258733loggish
marish114319053_marish
midrash1335423midrash
minish115216303mi_nish
minxish1936213minxish
moorish123311783moorish
nigrify1444133nigrify
noirish1037883noirish
nourish1039703nourish
ogreish1134673_ogreish
ogrism937913_ogrism
parish115022353_parish
perish114619063_perish
pinfish15319303pinfish
pinkish16279113pinkish
pixyish2253653pixyish
poorish123712303poorish
priggish1544683priggish
puggish14265993puggish
rigorism1145793rigorism
rigorist949123rigorist
roguish1156833roguish
sickish1638423sickish
sourish10310693sourish
stiffish1745243stiffish
tallish103313583tallish
tannish101610573tannish
tarnish101611873tarnish
tartish101512633tartish
tetris62816293tetris_
thickish2044603thickish
thievish1743263thievish
thinnish1454873thinnish
thrash12258363t_hrash
thresh12276863t_hresh
thrush12257483t_hrush
thuggish1642653thuggish
tiaras6314553tiaras_
ticklish1755283ticklish
tiering8315253tiering
tiers55526523tier_s_
tigerishly1752103tigerishly
tigers75616513tigers_
tights104015853tights_
tigons74112263tigons_
tikis95615973ti_kis_
tilefish1445453tilefish
tipis76019923ti_pis_
tires55437493ti_res_
tiring74023093ti_ring
tirls54519803ti_rls_
tiros54524893ti_ros_
titis56023813ti_tis_
titlist7312923titlist
titres64718933titres_
toadish1139063toadish
tonish93415903t_onish
tonnish10149093tonnish
toughish1545283toughish
tourism939423tourism
tourist7313203tourist
tovarish1445123tovarish
townish13167933townish
toyish122911123t_oyish
trash86119763t__rash
trickish1746793trickish
trigraph1445703trigraph
tsarism958253tsarism
tsarist7712253tsarist
tsoris63411193tsoris_
tsuris62710203tsuris_
tugrik1134283tugri_k
tugriks1233153tugriks
tundish1137283tundish
tzarism1866323tzarism
tzarist1659103tzarist
tzuris15286913tzuris_
viperish1655893viperish
voguish1465203voguish
waggish15207073waggish
wearish132310153wearish
whorish1636603whorish
widish13419363wi_dish
wildish1446853wildish
wimpish1765693wimpish
winish124212263wi_nish
wispish1575643wispish
woggish15276673woggish

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 Limit1340271386.98619185.1
3Display Results1381380.0463000.0
 (SQL Overall)1786911387.46823927.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.