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

162 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
silting8332048(None) 
hilting113316891hilting
jilting153211741jilting
kilting123213851kilting
lilting83515381lilting
milting103619121milting
salting84120791salting
sifting113014591sifting
silking123715591silking
siloing83215501siloing
siting74126621si_ting
sitting83519631sitting
stilting93312401stilting
tilting83417101tilting
wilting113515911wilting
ailing74331012ail_ing
airting83616302airting
belting104119132belting
bilging114212682bilging
bilking144413552bilking
billing103823852billing
biltong1034682biltong
biting95321822bi_ting
bitting103717292bitting
bolting104416762bolting
citing94220182ci_ting
dieting93616832dieting
dilating102714912dilating
diluting10248982diluting
dinting93520552dinting
felting113515212felting
fileting1239302fileting
filing103823762fil_ing
filling113520802filling
filming133210352filming
fisting113818122fisting
fitting113516562fitting
fliting113514612fliting
gifting123810892gifting
gilding103813002gilding
gilling93520382gilling
girting93113332girting
gitting93215702gitting
halting114419072halting
hilding123713532hilding
hilling113821772hilling
hinting113919222hinting
histing113720372histing
hitting113017272hitting
isling71213882isl_ing
jolting153410912jolting
killing123118722killing
kilning12289022kilning
kiltings13327082kiltings
kiting114117092ki_ting
kitling123313572kitling
kitting123214442kitting
lifting113313272lifting
linting83820982linting
listing84020592listing
malting103219082malting
melting103317752melting
milding113615452milding
milking143712762milking
milling103223682milling
minting103020812minting
misting103623382misting
molting103517172molting
nilling83619562nilling
oiling74925312oil_ing
pelting102917272pelting
piling95025592pil_ing
pilling103722562pilling
piloting1139692piloting
pitting103618872pitting
quilting18218712quilting
rifting113515002rifting
riling74227972ril_ing
rilling84023622rilling
rioting82716392rioting
sailing83927372sail_ing
sainting93215732sainting
saltine75018562saltine
saltings92811252saltings
saluting9310552saluting
salving113913152salving
sating74735452s_ating
seating84130682seating
selfing112911622selfing
selling83225832selling
setting83621392setting
shifting152910382shifting
shilling123315382shilling
shirting123213612shirting
shitting123212662shitting
shuting113212052shuting
sibling10814422sibling
siccing12319512siccing
sicking143720172sicking
siding83822132si_ding
sidling9915422sidling
sieging92613202sieging
sieving112311232sieving
siftings12236582siftings
sighing123311662sighing
sighting133110862sighting
signing92713962signing
siltier73413862siltier
singing93221422singing
sinking123320542sinking
sinning83918442sinning
siping94220632si_ping
sipping123117432sipping
siring75128312si_ring
sittings9339732sittings
sizing163616442si_zing
skating123613852skating
skilling132911332skilling
skirting13289392skirting
skiting123812502skiting
slating83724652slating
slicing103514642slicing
sliding93114552sliding
sliming102913952sliming
sling66028802s_l_ing
sliping103314412sliping
slitting93012582slitting
sluing74315882s_luing
smelting11339712smelting
smiling103915442smil_ing
smiting103014442smiting
soiling83422322soil_ing
solating9315592solating
soling74226822sol_ing
soloing82813802soloing
solving112910852solving
sooting82820962sooting
sorting83221812sorting
spiling102919702spil_ing
spilling113113942spilling
spirting112913632spirting
spiting103917622spiting
spitting113012322spitting
stating83725162stating
stilling93415322stilling
sting65330242s__ting
stinting93415742stinting
suiting83419002suiting
sulking124514312sulking
swilling123511932swilling
tiling73426552til_ing
tilling83522782tilling
tinting84620602tinting
titling83715792titling
welting113615312welting
wilding123814292wilding
wiling103024292wil_ing
willing113821612willing
wisting113519742wisting
witing103522822wi_ting
witling113215812witling
witting113417062witting

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 Filter1786911076710.623286823.4
2DLD Change Limit1076711626.70616055.9
3Display Results1621620.0602700.0
 (SQL Overall)1786911627.38924183.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.