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

104 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
digger9461608(None) 
bigger104315061bigger
dagger95017291dagger
digged104314651digged
diggers104413381diggers
dinger85323661dinger
dogger95216781dogger
jigger155313051jigger
nigger89713571nigger
rigger85616711rigger
agger76420892_agger
bagger104619202bagger
binger94923442binger
bugger104418722bugger
chigger1436002chigger
daggers103714912daggers
danger83722822danger
dialer74315432dialer
diaper94513112diaper
dibber114614712dibber
dicer85426422di_cer
dicier94416232dicier
dicker134521402dicker
dieter73516772dieter
differ133910842differ
diker105524552di_ker
dimer85625602di_mer
dimmer114112612dimmer
diner65632902di_ner
dinge75627302dinge_
dinged95221782dinged
dingers94321372dingers
dinges83825422dinges
dingey114914042dingey
dingier93513662dingier
dinner74217152dinner
dipper114017782dipper
direr64927072di_rer
dirge75117072dirge_
dirges84915102dirges
dither104417682dither
diver94827802di_ver
dodger95817042dodger
dogged106017702dogged
doggers104413432doggers
doggery13448262doggery
doggier103810942doggier
dragger10309162dragger
egger74414402_egger
figged124013892figged
finger104920322finger
fogger114414772fogger
gagger95016512gagger
gigged104112292gigged
giggler101029882giggler
ginger84920022ginger
higgler12369802higgler
higher134610892higher
hinger104723312hinger
hogger114615082hogger
hugger114713122hugger
igged86012762_igged
jagger154016002jagger
jigged164412772jigged
jiggers164010172jiggers
jiggier16377822jiggier
jogger154713162jogger
kegger12388062kegger
lagger85919832lagger
liger65024462li_ger
linger75225992linger
logger86420002logger
lugger83916552lugger
mugger103914702mugger
nagger84016122nagger
niggers93111312niggers
niggler93610292niggler
nigher103612752nigher
pigged114214152pigged
piggery14266182piggery
piggier113510002piggier
pinger94324082pinger
rigged94517402rigged
riggers93613832riggers
ringer74526052ringer
rugger84414512rugger
sagger84321072sagger
sigher103813702sigher
signer74015622signer
singer74227302singer
snigger9328372snigger
swigger12338452swigger
tagger84017692tagger
tiger65718632ti_ger
trigger9329152trigger
tugger84013102tugger
wagger113616012wagger
wigged124413582wigged
wiggery15295862wiggery
wiggier12418862wiggier
wiggler123110762wiggler
winger104125432winger
zigged184110192zigged
zinger163816692zinger

Search took 6 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 Filter178691825510.1101624463.6
2DLD Change Limit825511044.06320317.7
3Display Results1041040.0761368.4
 (SQL Overall)1786911044.24942054.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.