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

140 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
raggs7521647(None) 
jaggs148111491jaggs
ragas65326061ragas
rages64539441rages
ragg65622691ragg_
raggy106116571raggy
ragis66325601ragis
rags55448371ra_gs
agas55938842_agas
ages55844592_ages
ags47551662_a_gs
argus66716542argus
baggy125615682baggy
bags76645502ba_gs
bangs85627772bangs
braggy13337172braggy
brags85625102bra_gs
cages85936012cages
craggy13396602craggy
crags85622572cra_gs
dagga839542dagga
daggas937972daggas
dagos76419442dagos
dags66642592da_gs
dangs75623202dangs
draggy12346822draggy
drags75521112dra_gs
eggs66516152_eggs
faggy136514372faggy
fags86939122fa_gs
fangs96224072fangs
frags96322162fra_gs
gages74529972gages
gags66441062ga_gs
gangs76222572gangs
haggis11209512haggis
hags86740842ha_gs
hangs95726722hangs
hoggs107212462hoggs
iggs66612672_iggs
jagg136115312jagg_
jaggy175913142jaggy
jags126132792ja_gs
kagus105812032kagus
lags56546222la_gs
mages85036022mages
mags75444522ma_gs
magus85318752magus
miggs96311372miggs
muggs94912322muggs
naggy106612822naggy
nags55436022na_gs
noggs75811182noggs
orangs74116032orangs
pages85235072pages
pangs84628662pangs
prangs94816232prangs
races74943242races
racks115028852racks
rads56046602ra_ds
raffs115017522raffs
rafts87820632rafts
rag45761322ra_g_
raga55930812ra_ga
ragbags1135112ragbags
rage55742352ra_ge
raged74829452raged
ragee65432662ragee
ragees74618662ragees
ragged94620262ragged
raggee84217602raggee
raggees93710912raggees
raggies93214732raggies
raggle83712882raggle
raggles93813282raggles
ragi56032282ra_gi
ragtags935372ragtags
raias54631122raias
raids65827512raids
rails55937402rails
rains55140232rains
rais45252622ra_is
rajas127317722rajas
rajes125022782rajes
rakes94440352rakes
rakis95323442rakis
rakus94413672rakus
rales54947492rales
ramps96224632ramps
rams65950772ra_ms
ramus76418282ramus
rands65930452rands
rang56939152rang_
range64728412range
ranges73826922ranges
rangy95320382rangy
ranis55235832ranis
ranks95225732ranks
rants55935342rants
rapes75740722rapes
raps66247732ra_ps
rares55247442rares
ras37575392ra__s
rases55447212rases
rasps74316662rasps
rates55352012rates
ratos55528762ratos
rats46260372ra_ts
raves85441972raves
raws75238212ra_ws
raxes124729392raxes
rayas85922052rayas
rays77642352ra_ys
razes145032702razes
reges65628782reges
regs55436572r_egs
rigs55137592r_igs
rings65029172rings
rugs56033682r_ugs
rungs611819402rungs
sagas66025882sagas
sages65339062sages
saggy105917462saggy
sagos66123872sagos
sags55948402sa_gs
tags55545232ta_gs
tangs65028342tangs
teggs74710742teggs
tragus749222tragus
vagus96713812vagus
vangs96319582vangs
vuggs10579132vuggs
wages95330932wages
wags86140552wa_gs
wrangs104611912wrangs
yagis95416572yagis
yags86632292ya_gs
yangs95618692yangs
yeggs10608162yeggs
zags146826682za_gs

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 Filter178691538000.0931921408.6
2DLD Change Limit538001401.90628226.7
3Display Results1401400.0761842.1
 (SQL Overall)1786911402.07586116.1
 
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.