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

121 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
rigger8561671(None) 
bigger104315061bigger
digger94616081digger
jigger155313051jigger
nigger89713571nigger
rigged94517401rigged
riggers93613841riggers
ringer74526061ringer
rugger84414511rugger
trigger9329161trigger
agger76420892_agger
bagger104619202bagger
binger94923452binger
bragger113810042bragger
bringer104213352bringer
bugger104418722bugger
chigger1436002chigger
cringer103514242cringer
dagger95017302dagger
digged104314652digged
diggers104413392diggers
dinger85323672dinger
dogger95216782dogger
dragger10309172dragger
egger74414412_egger
figged124013892figged
finger104920332finger
fogger114414782fogger
frigged13439052frigged
gagger95016512gagger
gigged104112292gigged
giggler101029882giggler
ginger84920032ginger
higgler12369802higgler
higher134610892higher
hinger104723332hinger
hogger114615082hogger
hugger114713122hugger
igged86012762_igged
jagger154016002jagger
jigged164412772jigged
jiggers164010182jiggers
jiggier16377822jiggier
jogger154713162jogger
kegger12388082kegger
lagger85919832lagger
liger65024472li_ger
linger75226002linger
logger86420002logger
lugger83916552lugger
mugger103914702mugger
nagger84016122nagger
niggers93111322niggers
niggler93610292niggler
nigher103612752nigher
pigged114214152pigged
piggery14266192piggery
piggier113510002piggier
pinger94324092pinger
prigged12398932prigged
priggery1543992priggery
progger11319372progger
ragged94620262ragged
raggee84217602raggee
ranger73925532ranger
rejigger1743182rejigger
ribber103515492ribber
ribier84414232ribier
ricer74726612ri_cer
richer114015042richer
ridder84015142ridder
rider65231312ri_der
ridge75018682ridge_
ridged94014222ridged
ridgel8399972ridgel
ridges85817012ridges
ridgier937882ridgier
riever94811652riever
rifer84721982ri_fer
rifler94014262rifler
righter113212382righter
rigor62714052ri_gor
rigour7258022rigour
rimer75429242ri_mer
rimier83916272rimier
rimmer103516032rimmer
ringed84623842ringed
ringers83922952ringers
rinser64317212rinser
rioter64817282rioter
riper74328402ri_per
ripper103518652ripper
riser55431052ri_ser
risker105414492risker
ritter63822422ritter
river85731692ri_ver
roger64521412r_oger
rugged94215382rugged
ruggers94612312ruggers
sagger84321072sagger
sigher103813702sigher
signer74015632signer
singer74227312singer
snigger9328372snigger
sprigger12366502sprigger
swigger12338452swigger
tagger84017712tagger
tiger65718632ti_ger
trigged10359852trigged
triggers10257842triggers
tugger84013102tugger
wagger113616012wagger
wigged124413582wigged
wiggery15295872wiggery
wiggier12418862wiggier
wiggler123110762wiggler
winger104125442winger
wriggler13295262wriggler
wringer113612452wringer
zigged184110192zigged
zinger163816702zinger

Search took 3 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.343520965.0
2DLD Change Limit825511212.59331836.1
3Display Results1211210.0462630.4
 (SQL Overall)1786911212.98259923.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.