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

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

96 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
tricksinesses196243(None) 
trickinesses1845221trick_inesses
pricklinesses2143622pricklinesses
trickishnesses2352502trickishnesses
tricksiness1762942tricksine_s_s
friskinesses1944773frisk_inesses
ickinesses1637183__ick_inesses
pickinesses1996833_pick_inesses
prissinesses1355953pri_ssinesses
riskinesses1537833_risk_inesses
rockinesses1737363_rock_inesses
sicklinesses1844863_sicklinesses
stickinesses1845083stick_inesses
tackinesses1737253t_ack_inesses
thicknesses2043913thick__nesses
tipsinesses1336363t_i_psinesses
trickiness1666353trick_ine_s_s
agribusinesses1751664agribusinesses
artsinesses1138714ar__tsinesses
brackishnesses2552644brackishnesses
brassinesses1346064br_assinesses
brininesses1338984bri__ninesses
brisknesses1745584bri__sknesses
cockinesses1947564_cock_inesses
cosinesses121012824___cosinesses
crankinesses1846144crank_inesses
creakinesses1845994creak_inesses
crispinesses1645004cri_spinesses
crispnesses1545944cri__spnesses
ditsinesses12108764_di_tsinesses
dressinesses1245524dr_essinesses
drowsinesses1644384dr_owsinesses
ficklenesses2144154_ficklenesses
finickinesses2272064finick_inesses
flimsinesses1743994fli_msinesses
folksinesses1964064_folksinesses
freakinesses1945594freak_inesses
frizzinesses2342934fri_zzinesses
greasinesses1347044gr_easinesses
griminesses14167554gri__minesses
grislinesses1345824gri_slinesses
gristlinesses1443994gristlinesses
grittinesses1345844gri_ttinesses
icinesses11310074__ic__inesses
inkinesses1439424__ink_inesses
juicinesses2035894juic__inesses
kinkinesses1435874_kink_inesses
luckinesses1746654_luck_inesses
milkinesses1786794_milk_inesses
noisinesses1139484noi__sinesses
pluckinesses2043994pluck_inesses
precisenesses1756284precisenesses
prickliness1943904prickline_s_s
princelinesses1892724princelinesses
prosinesses13310854pr__osinesses
quicknesses2643754quick__nesses
quirkinesses2542894quirk_inesses
racinesses12313514_rac__inesses
richnesses1537804_ric__hnesses
riminesses121211414_ri__minesses
ritzinesses2096744_ri_tzinesses
rosinesses101213144_r__osinesses
sickishnesses2143664_sickishnesses
sicknesses1636764_sick__nesses
silkinesses1557904_silk_inesses
sissinesses9118314_si_ssinesses
slicknesses1745194slick__nesses
slinkinesses1645814slink_inesses
spicinesses1547104spic__inesses
spikinesses1746524spi_k_inesses
stockinesses1844504stock_inesses
streakinesses1743634streak_inesses
strictnesses1445414stric__tnesses
stringinesses14124534stri_nginesses
talkinesses1537354t_alk_inesses
tetchinesses1753554tetc_hinesses
thirstinesses1642584thirstinesses
thriftinesses1952314thri_ftinesses
ticklishnesses2352384t_icklishnesses
tidinesses1139224t_i__dinesses
timelinesses1445454t_imelinesses
tininesses10311164t_i__ninesses
tinninesses1136864t_i_nninesses
touchinesses1744244touc_hinesses
trashinesses1546114tr_ashinesses
trendinesses1346324tr_endinesses
trichinoses1653234tric_hin_oses
trickishness2152524trickishne_s_s
tricksiest1644354tricksi_e_s_t
trignesses1188214tri___gnesses
trimnesses1287754tri___mnesses
tritenesses11710394tri__tenesses
trustinesses12116984tr_ustinesses
wackinesses2036654_wack_inesses
wickednesses2243274_wickednesses
yuckinesses2044764_yuck_inesses

Search took 6 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 Filter178691950240.390458182.1
2DLD Change Limit95024964.89019432.3
3Display Results96960.0631523.8
 (SQL Overall)178691965.34333443.9
 
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.