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

264 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
diggings1231662(None) 
biggings13327471biggings
digging113513701digging_
riggings11327131riggings
wiggings14316171wiggings
baggings13307522baggings
bigging122815882bigging_
biggins113410692biggin_s
dialings10329822dialings
dinging103618612dinging_
dogging113312692dogging_
figging133313562figging_
gigging93311772gigging_
igging93212072_igging_
jigging173011552jigging_
joggings18264632joggings
laggings11298402laggings
leggings11316192leggings
loggings11398232loggings
muggings13244592muggings
nigglings12213732nigglings
noggings11285742noggings
pigging123614672pigging_
piggins113010472piggin_s
rigging103016332rigging_
wigging133413832wigging_
zigging193210532zigging_
ageings9437693_ageings
agings86312673__agings
airings83913843ai_rings
anglings10228273anglings
bagging123316983bagging_
begging123012653begging_
biddings13397563biddings
biggies113813523biggi_es
biggin103710603biggin__
bigwigs1443003bigwi_gs
bilging114212683bilging_
billings113412633billings
bindings123810473bindings
binging113619383binging_
birdings12378823birdings
birlings11359613birlings
bittings11339293bittings
blaggings14324463blaggings
bloggings14264263bloggings
bogging123615753bogging_
bridgings14254293bridgings
bugging123515183bugging_
cogging123513713cogging_
daggling12237063daggling_
dairyings1442633dairyings
dampings14377523dampings
danging103716093danging_
darings93713653d_arings
darlings103710383darlings
darnings10378553darnings
dealings103510703dealings
deckings16346683deckings
deigning1137753deigning_
designings1342623designings
dialing94318173dialing_
diallings1134993diallings
diamines11311643diamines
diamins10312213diamin_s
diazines1838713diazines
diazins1739183diazin_s
dibbing133110893dibbing_
dicing105718763di_cing_
dicking153617613dicking_
dieing84018653di_eing_
dieting93616833dieting_
diggers104413393digg_ers
dighting142510843dighting_
digits84114533di_gi_ts
digoxins1744293digoxin_s
diking124320243di_king_
dimming13339593dimming_
dingdongs1341903dingdongs
dingies93618243dingi_es
dinginess1137823dinginess
dings76331403d___ings
dining84525133di_ning_
dinking133618283dinking_
dinning93416553dinning_
dinting93520553dinting_
dioxins1568003dioxin_s
dipping134014833dipping_
dirking133812603dirking_
dirling93316073dirling_
discing113914593discing_
dishing124017103dishing_
disking134615493disking_
dissing94517683dissing_
divines113514723di_vines
diving113717953di_ving_
dodging11299063dodging_
doggies103613023doggi_es
doggones1135713doggones
doings84913183d__oings
dopings11408783d_opings
dragging12308103dragging_
drawings13386283drawings
dredgings13252953dredgings
drillings11285823drillings
drinkings15244773drinkings
drippings15313903drippings
drivings13265763drivings
drugging12326443drugging_
dubbings14245473dubbings
ductings12346673ductings
dugongs1053253d_ugongs
dumpings14295763dumpings
dunging103012623dunging_
dustings10419033dustings
dyeings12374643d_yeings
dyings11478133d__yings
edgings10256243_edgings
egging93210983_egging_
fagging133714763fagging_
fidging133910503fidging_
fightings17276503fightings
filings115213073fi_lings
fillings122910503fillings
findings13328443findings
finings114311773fi_nings
firings114112333fi_rings
fishings15307693fishings
fittings12318203fittings
fixings18347443fi_xings
fizgigs2142203fizgi_gs
flaggings15285183flaggings
floggings15314123floggings
fogging133513733fogging_
forgings13287703forgings
fraggings15324243fraggings
frigging14268953frigging_
fugging133912913fugging_
gagging93013533gagging_
giggling10227043giggling_
gildings11356973gildings
ginnings10366523ginnings
goings84911523__goings
hagging133114683hagging_
hangings13258583hangings
hidings12349703hi_dings
higgling14217163higgling_
hildings13347503hildings
hinging123917123hinging_
hissings12556753hissings
hogging133112803hogging_
hugging132710633hugging_
icings9428453_i_cings
imagings1234553imagings
impings12348553_impings
innings8329443_innings
jagging173311993jagging_
jiggling18226363jiggling_
jogging173211233jogging_
jugging172910723jugging_
jugglings19212723jugglings
kegging14328293kegging_
keglings14245233keglings
killings133710483killings
kiltings13327083kiltings
kinging133115033kinging_
kitlings13318103kitlings
lagging103316743lagging_
legging103912643legging_
leggins9259473leggin_s
lickings15298143lickings
lightings14277723lightings
lignins84010493lignin_s
likings12539413li_kings
linings84313073li_nings
lippings13296093lippings
listings93310043listings
livings11408923li_vings
lodgings11336243lodgings
logging103316813logging_
longings10408563longings
lugging104114353lugging_
millings113712583millings
minings103912073mi_nings
mogging123311493mogging_
mugging122711793mugging_
muggins11248073muggin_s
nagging102613043nagging_
niggling11227443niggling_
nighing123410063nighing_
nogging103612723nogging_
noggins9288453noggin_s
pagings114411063_pagings
pargings123410163pargings
pegging122811133pegging_
pickings17359383pickings
pidgins11259123pidgin_s
piecings1345343piecings
piggies113813483piggi_es
piggin103111093piggin__
pigginess1375453pigginess
pilings103313613pi_lings
pinging113419553pinging_
pinkings15338143pinkings
pipings12338253pi_pings
pittings11349123pittings
prigging13299093prigging_
pugging122912543pugging_
purgings12347293purgings
ragging103516683ragging_
ribbings13275923ribbings
ridging104112983ridging_
ridglings12214183ridglings
ridings93412093ri_dings
riflings12227303riflings
ringing93521283ringing_
rinsings9318013rinsings
risings83211893ri_sings
rugging102512763rugging_
sagging103116103sagging_
sergings10299213sergings
siblings11108123siblings
sidings94011463si_dings
sieging92613203sieging_
siftings12236583siftings
sighing123311663sighing_
sightings14256533sightings
signing92713963signing_
singing93221423singing_
sittings9339733sittings
sizings17378013si_zings
stagings10378343stagings
swigging14337223swigging_
swingings14275053swingings
tagging103014913tagging_
tickings15368583tickings
tidings93810263ti_dings
tilings84212793ti_lings
timings10279303ti_mings
tinging93619463tinging_
tintings9288713tintings
tithings12327693tithings
togging103512743togging_
trigging11299583trigging_
tugging102611233tugging_
twigging14305673twigging_
vegging13308873vegging_
viewings1533983viewings
vikings15386623vi_kings
virgins1137863virgin_s
voguings13213113voguings
wagging133313353wagging_
wickings18357183wickings
wiggling14217293wiggling_
wildings13287933wildings
windings13329973windings
wingdings1543683wingdings
winging123718713winging_
winnings12327583winnings
wirings113910113wi_rings
witlings12328443witlings
wittings12328733wittings
zagging193210453zagging_
zinging183513943zinging_

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622646.04624175.0
3Display Results2642640.1102400.0
 (SQL Overall)1786912646.57927160.8
 
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.