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

226 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
ruled6582252(None) 
muled85824431muled
puled84926521puled
riled65833251riled
rued55729791ru_ed
rule49938421rule_
ruler54923341ruler
rules55234251rules
abled86926832abled
ailed66240282ailed
argled85314552argled
ariled75620322ariled
auld54125362aul_d
axled135315812axled
baled85436442baled
bled75729312_bled
blued84520322blued
bruted95113262bruted
bruxed16466982bruxed
bugled104918132bugled
bulbed114312772bulbed
bulged105117122bulged
bulked134216742bulked
bulled94626492bulled
burled94825382burled
bused85624492bused
butled94818602butled
clued84917682clued
coled85540752coled
cubed105519702cubed
cued76329562cu_ed
culet76040342culet
culex144613932culex
culled94022472culled
culmed114610592culmed
cured85932132cured
curled95021652curled
deled75326542deled
doled75430912doled
duded84417132duded
dueled84813662dueled
duked115218462duked
dulled84719422dulled
duped95118322duped
dured75025402dured
feruled11318412feruled
filed95331902filed
fled85429772_fled
flued95021252flued
fouled104315972fouled
fueled104913602fueled
fugled114813692fugled
fulled103820652fulled
fumed116118822fumed
furled104717052furled
fused94820442fused
fuzed185415252fuzed
gled65631142_gled
glued75118362glued
grueled937132grueled
guiled84315382guiled
gules64831042gules
gulfed114810012gulfed
gulled84521372gulled
gulped104610372gulped
guyed1049892guyed
haled95335822haled
hauled104415212hauled
holed95634132holed
hued86925852hu_ed
hulked144611302hulked
hulled103920012hulled
hurled104617452hurled
idled74915212idled
isled64615992isled
juked175714072juked
julep14310532julep
led46254552__led
lubed85319892lubed
luged74019092luged
lulled74516442lulled
lured65427492lured
luted64826142luted
mauled94817822mauled
mule65236972mule_
mules75034292mules
muley104819282muley
mulled94721552mulled
mured85726702mured
mused85524582mused
muted85023382muted
naled65525052naled
nuked104014182nuked
nulled74318272nulled
nurled74016232nurled
ogled75915962ogled
oiled64429472oiled
outed65429062outed
outled74020342outled
paled85538722paled
piled85232992piled
pled75231432_pled
poled84934842poled
pruned93413112pruned
puked124716222puked
pule65040952pule_
puler74826622puler
pules74538812pules
pulled94322192pulled
pulped114612532pulped
pulsed94013722pulsed
purled94520742purled
raced87635312raced
raged74829452raged
railed74727542railed
raked105831422raked
rale45050562rale_
rales54947492rales
raped85334622raped
rared65738322rared
rased65033932rased
rated65441382rated
raved94931432raved
raxed135622662raxed
rayed95127502rayed
razed155027982razed
red46755802r__ed
reded74829112reded
reed55549622r_eed
reeled74725532reeled
refed93921922refed
relend76116452relend
relet54749822relet
relied74926232relied
repled93319772repled
reused75419562reused
rewed95425452rewed
riced85825542riced
rifled104115002rifled
rile45650532rile_
riles55343642riles
riley84420582riley
rilled74525652rilled
rimed84826372rimed
riped85226432riped
rived94825612rived
robed85323732robed
roiled74320052roiled
role45851822role_
roles56747982roles
rolfed104510522rolfed
rolled74220242rolled
roped84630802roped
rosed65930342rosed
rouged86717322rouged
rouped95717352rouped
roused75426442roused
routed75624332routed
roved95323552roved
rowed94034322rowed
rubbed114515082rubbed
rubbled124611622rubbled
rube65532012rube_
rubel75416832rubel
rubes74928412rubes
rubied94312412rubied
ruble74521252ruble_
rubles83921702rubles
ruched124314632ruched
rucked134718762rucked
ruckled144111032ruckled
rudd65917472ru_dd
ruddled103010872ruddled
rude55632782rude_
ruder65320542ruder
rue35549262ru_e_
ruer46127562ru_er
rues46044482ru_es
ruffed134312742ruffed
ruffled14369152ruffled
rugged94215372rugged
ruined74813322ruined
rulers64317092rulers
rulier65016352rulier
ruly76323142rul_y
rumbled124514592rumbled
rumen74419502rumen
rumpled123810012rumpled
rune45236292rune_
runes55530222runes
runkled12399012runkled
runlet63821412runlet
rupee7321282rupee
ruse45938932ruse_
ruses56136582ruses
rushed104419862rushed
rusted75020922rusted
rustled83311322rustled
rutted74518402rutted
ryked13669512ryked
sled55334372_sled
slued64220512slued
soled65835172soled
souled75419822souled
sued56537932su_ed
sulked114314702sulked
tiled64832942tiled
toled65934922toled
truced95312052truced
trued65117692tru_ed
tubed85818042tubed
tule45735872tule_
tules54532792tules
tuned64622312tuned
unled64021072unled
unruled8311372unruled
urged75316032urged
urped84615282urped
used55722822_used
voled95323722voled
waled94330992waled
wauled104713962wauled
wiled95231552wiled
wyled124611842wyled
yule75725142yule_
yules84521582yules

Search took 2 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 Limit538002261.81329674.6
3Display Results2262260.0633587.3
 (SQL Overall)1786912261.96990752.2
 
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.