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

60 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
spangliest134516(None) 
dangliest1137172_dangliest
gangliest1137672_gangliest
jangliest1746382_jangliest
slangiest10129082slang_iest
spangles1138892spangl_es_
spanglier1244192spanglie_r
sparkliest1644582sparkliest
spindliest1344492spindliest
spongiest1237092spong_iest
tangliest1068422_tangliest
angriest9310253__angriest
jingliest1735973_jingliest
jungliest1744923_jungliest
kingliest1436523_kingliest
mangiest112815903_mang_iest
manliest102314943_man_liest
orangiest1038463orang_iest
paliest93021613_pa__liest
palliest102814653_pa_lliest
panelist10414513_paneli_st
rangiest93115983_rang_iest
saggiest102812723s_a_ggiest
sagiest82617993s_a_g_iest
saintliest1046023saintliest
sandiest93218693s_an_diest
scaliest101714403sca__liest
scantiest112611013scan_tiest
scraggliest1542483scraggliest
shaggiest14156903sha_ggiest
shaliest111415063sha__liest
shapeliest1544973shapeliest
skankiest12145713skan_kiest
slaggiest11157713sla_ggiest
snaggiest11126683sna_ggiest
snarliest91810213sna_rliest
spaciest122310903spa__ciest
spangle1038403spangl_e__
spangled1236153spangl_e_d
spangling1336373spangli_ng
spanless10247363span_l_ess
sparkiest15188103spa_rkiest
sparriest11198793spa_rriest
spendiest1237533spen_diest
spiniest102813233spin__iest
sprawliest1543583sprawliest
spriggiest14174543spriggiest
springiest13156683spring_iest
spunkiest15166573spun_kiest
staggiest11148263sta_ggiest
stagiest91613413sta_g_iest
stateliest1046363stateliest
stingiest10209773sting_iest
straggliest1343613straggliest
swankiest16136213swan_kiest
swingiest13207573swing_iest
tangiest92915223_tang_iest
tingliest1047683_tingliest
twangiest1355223twang_iest
waggliest1434783_waggliest

Search took 7 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 Filter1786911406030.440406115.9
2DLD Change Limit140603606.28022389.0
3Display Results60600.0331818.2
 (SQL Overall)178691606.75326461.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.