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

103 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
splurgy134302(None) 
splurge1044761splurge
sludgy11366252s_ludgy
slurry9378602s_lurry
splurged1243922splurged
splurger1143812splurger
splurges1145162splurges
spurge93711322sp_urge
spurry11429122sp_urry
surgy95118522s__urgy
allergy1144503allergy
blurry11437673_blurry
clergy1234993_clergy
flurry12397113_flurry
kludgy15294223_kludgy
liturgy1142873liturgy
plucky17406583_plucky
plug74915993_plu_g_
plugs85213493_plu_gs
plummy15375663_plummy
plumy124213233_plu_my
plunge93811053_plunge
plunky15377953_plunky
plural839823_plural
plushy14406973_plushy
porgy116916123_p_orgy
pudgy124911163_p_udgy
puggy124612323_p_uggy
purge85324603_p_urge
pursy105016413_p_ursy
purty105019403_p_urty
salary9515213salar_y
saury84317223s_aur_y
scourge1035653scourge
scurfy14338763s_curfy
scurry11419593s_curry
scurvy14386103s_curvy
shlumpy1742863shlumpy
silurid837013silurid
slaggy11438793s_laggy
slangy105411393s_langy
sludge84811943s_ludge
slug55124643s_lu_g_
slugs64618563s_lu_gs
sluicy1166483s_luicy
slummy13325863s_lummy
slung65117833s_lung_
slur45525153s_lur__
slurb74116323s_lur_b
slurbs8439743s_lurbs
slurp74014983s_lur_p
slurps84410003s_lurps
slurs54123373s_lur_s
slushy12417223s_lushy
slutty9248003s_lutty
smudgy13294133s_mudgy
solubly1255283solubly
sourly93612213s_ourly
sparge94216053sp_arge
sparky154511523sp_arky
sparry115111303sp_arry
sphery14318883spher_y
spiry105017353sp_ir_y
splashy1543553splashy
splay105816043spl__ay
spleeny1234563spleeny
splodge1134103splodge
splore81611303splor_e
splores91910953splores
splurgers1253073splurgers
splurgier1252343splurgier
splurging1333623splurging
spongy1236743sp_ongy
sporty115112493sp_orty
spray106720063sp__ray
spriggy14374213spriggy
springy13359663springy
sprucy13356323spru_cy
sprug85313893spru_g_
sprugs94010173spru_gs
sprung94610033sprung_
spry96819123sp__r_y
spumy124610363sp_u_my
spunky15427163sp_unky
spur65321193sp_ur__
spurges104111653sp_urges
spurn74815453sp_ur_n
spurns84811383sp_urns
spurrey12307813spurrey
spurs74621523sp_ur_s
spurt77227983sp_ur_t
spurts84814973sp_urts
stoury9529943stour_y
sturdy1037043s_turdy
sulfury1345163sulfur_y
sultry938463sultr_y
surfy115319473s__urfy
surge65027693s__urge
surly85124433s__urly
synergy1442943synergy
theurgy1442733theurgy
upsurge10134333upsurge
zymurgy2541013zymurgy

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 Filter1786911340270.483369960.7
2DLD Change Limit1340271036.43620824.6
3Display Results1031030.0333121.2
 (SQL Overall)1786911036.95225703.5
 
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.