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 “serving” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

106 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
serving11301498(None) 
nerving112910831nerving
serging93416671serging
sering74731811ser_ing
servings12249221servings
swerving1546111swerving
berming123614832berming
carving133916772carving
cering94522532cer_ing
cervine122610802cervine
curving133912102curving
deaving123814752deaving
delving123711572delving
deriving132510742deriving
deserving1497902deserving
erring73816482_erring
heaving144114762heaving
helving144011132helving
herding122915122herding
herring113615882herring
jerking19308922jerking
kerbing14308482kerbing
kerfing15307532kerfing
kerning124010892kerning
leaving114216852leaving
merging112711762merging
nervine102510622nervine
nervings12256322nervings
observing1544382observing
peeving135112242peeving
perking143716462perking
perming123416092perming
reaving113820532reaving
reeving113717662reeving
reiving113316842reiving
reserving131110642reserving
revving14379342revving
salving113913152salving
saving104724512s_aving
scriving14258762scriving
scrying1338662scrying
sealing83528562sealing
seaming103222112seaming
searing83330922searing
seating84130682seating
seeding93719482seeding
seeing74222142se_eing
seeking124016062seeking
seeling83522002seeling
seeming103216262seeming
seeping103817912seeping
seining84020772seining
seising84018862seising
seizing174114832seizing
selfing112911622selfing
selling83225832selling
sending94221372sending
sensing84116952sensing
serein63318462serein_
sereins73716112sereins
sergings10299212sergings
serin55434442ser_in_
serine65432672ser_ine
seringa83310742ser_inga
serins64029672ser_ins
serrying12167692serrying
servant10313622servant
service1239082service
servicing1545342servicing
servile10310642servile
setting83621392setting
sewing103819622se_wing
sexing144313892se_xing
shaving143414332shaving
sheaving154110252sheaving
shelving15278172shelving
shoving142910642shoving
shriving15268452shriving
sieving112311232sieving
siring75128312sir_ing
skiving15298372skiving
slaving113514832slaving
sleaving123310982sleaving
sleeving12359282sleeving
smerking15258472smerking
solving112910852solving
sorbing102815262sorbing
soring74731882sor_ing
sorning83116812sorning
sorting83221812sorting
spring94526012spr_ing
starving122510172starving
staving113915702staving
steeving12359652steeving
sterling93615552sterling
string75327562str_ing
striving122611392striving
surfing112914482surfing
surging93115432surging
swiving14358952swiving
terming104016002terming
verging123812302verging
versing112314192versing
weaving143211622weaving
yerking15368812yerking
zeroing1738342zeroing

Search took 5 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 Filter1786911076710.373479064.3
2DLD Change Limit1076711064.37624604.9
3Display Results1061060.0761394.7
 (SQL Overall)1786911064.82537034.4
 
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.