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

84 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
spanglier124419(None) 
danglier1056752_danglier
ganglier1047602_ganglier
janglier1656112_janglier
slangier9117932slang_ier
spangle1038402spangl_e_
spangled1236152spangl_ed
spangles1138892spangl_es
spangliest1345162spangliest
spangling1336372spangling
sparklier1554362sparklier
spindlier1253872spindlier
spongier1135742spong_ier
tanglier948072_tanglier
angler74017863__angl_er
angrier839023__angrier
dangler96912813_dangl_er
espalier1036363espa__lier
gangliar1064123_gangliar
jangler153811833_jangl_er
jinglier1655233_jinglier
junglier1644303_junglier
kinglier1345633_kinglier
mangier104114063_mang_ier
mangler103215643_mangl_er
manlier92414023_man_lier
orangier947713orang_ier
palier85023563_pa__lier
pallier94417163_pa_llier
panier84425503_pan__ier
pannier93613353_pan_nier
rangier83714353_rang_ier
saggier92912063s_a_ggier
sagier73717163s_a_g_ier
saintlier954623saintlier
sallier73320423s_a_llier
sandier84017843s_an_dier
sanger74524573s_ang__er
scalier94316913sca__lier
scantier10309983scan_tier
scragglier1442283scragglier
shaggier13116053sha_ggier
shalier103116423sha__lier
shanghaier17122253shanghaier
shapelier1444463shapelier
shingler12268633shingl_er
skankier11184883skan_kier
slaggier10126953sla_ggier
snaggier10136303sna_ggier
snarlier8278183sna_rlier
spacier114011633spa__cier
spaller92713473spa__ller
spangly1336473spangl__y
spaniel948923span__iel
spanker133612353span__ker
spanner94312563span__ner
sparger103613083sparg__er
sparkier14298033spa_rkier
sparkler14317983sparkl_er
sparrier10329143spa_rrier
spendier1147143spen_dier
spindler11297983spindl_er
spinier93715163spin__ier
sponger1038523spong__er
sprawlier1443293sprawlier
spriggier1343843spriggier
springier1236023spring_ier
spunkier14235823spun_kier
staggier10167513sta_ggier
stagier83513443sta_g_ier
statelier945653statelier
stingier9279123sting_ier
stragglier1243503stragglier
strangler10369473strangl_er
swankier15225503swan_kier
swingier12267003swing_ier
tangier83013913_tang_ier
tangler83515083_tangl_er
tinglier956403_tinglier
twangier1254243twang_ier
twangler1244113twangl_er
wagglier1344323_wagglier
wangler113312653_wangl_er
wrangler1245473wrangl_er

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 Filter1786911486410.406440125.6
2DLD Change Limit148641847.45319943.8
3Display Results84840.0332545.5
 (SQL Overall)178691847.89222642.0
 
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.