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

174 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
ruler5492334(None) 
puler74826621puler
ruder65320541ruder
ruer46127561ru_er
rule49938421rule_
ruled65822521ruled
rulers64317091rulers
rules55234251rules
rulier65016351rulier
abler75624312abler
auger64922472auger
aulder7511452aulder
baler75635272baler
bluer74918492bluer
bugler94717722bugler
bulger94917352bulger
burler84723832burler
butler84220032butler
buyer105013092buyer
coruler9311712coruler
cruder95612382cruder
crueler939022crueler
cruller968752cruller
cuber95222532cuber
culet76040342culet
culex144613932culex
culler84322252culler
culver113010632culver
curer75030752curer
curler85221322curler
cuter74728232cuter
cutler84718032cutler
dueler74213682dueler
duller74017702duller
duper85519002duper
filer85433002filer
fouler93614902fouler
fueler94313932fueler
fuller94220382fuller
fumer105918232fumer
furler93616402furler
gluer65116772gluer
grueler837022grueler
gular6314832gular
gules64831042gules
gulper93410212gulper
haler85033522haler
hauler95015122hauler
huger94914872huger
huller93919102huller
hurler94717222hurler
idler65015662idler
iller54821292iller
julep14310532julep
kruller1145152kruller
luger65322082luger
luller63415482luller
lurer54625312lurer
mauler84416712mauler
miler75733062miler
mule65236972mule_
muled85824432muled
mules75034292mules
muley104819282muley
muller83820352muller
muser76024122muser
muter74525542muter
nuder66416832nuder
ogler65917442ogler
oiler54628282oiler
outer55633302outer
paler75436932paler
poler74431792poler
pruner83413452pruner
pule65040952pule_
puled84926522puled
pulers83820282pulers
pules74538812pules
puller83820812puller
pulper103513272pulper
pulser84215192pulser
purer75127902purer
queer143712812queer
racer75233022racer
railer64524932railer
raker94529792raker
rale45050562rale_
rales54947492rales
raper74932752raper
rarer54731702rarer
raser55633412raser
rater54943282rater
raver85631492raver
rawer84623732rawer
razer144824272razer
realer63528592realer
reeler63822572reeler
refer84822142refer
relet54749822relet
relier65826182relier
ricer74726612ricer
rider65231302rider
rifer84721982rifer
rifler94014262rifler
rile45650532rile_
riled65833252riled
riles55343642riles
riley84420582riley
rimer75429242rimer
riper74328402riper
riser55431052riser
river85731692river
roger64521412roger
role45851822role_
roles56747982roles
rolfer94412272rolfer
roller63919792roller
roper75431912roper
rouser65224082rouser
router65025842router
rover85527372rover
rower85430492rower
rubber104715792rubber
rube65532012rube_
rubel75416832rubel
rubes74928412rubes
rubier84814742rubier
ruble74521252ruble_
rubles83921702rubles
rudder83812802rudder
rude55632782rude_
rudery10419032rudery
rue35549262ru_e_
rued55729792ru_ed
ruers515019412ru_ers
rues46044482ru_es
ruffler13369722ruffler
rugger84414512rugger
ruiner64013642ruiner
ruly76323142rul_y
rumbler113514112rumbler
rumen74419502rumen
rummer104715482rummer
rumor71011322rumor
rune45236292rune_
runes55530222runes
runlet63821412runlet
runner63814462runner
rupee7321282rupee
ruse45938932ruse_
ruses56136582ruses
rusher94019652rusher
rustler73512342rustler
suber74924502suber
suer45334032su_er
sulker104015922sulker
super74924482super
surer54833092surer
sutler63718392sutler
taler56034862taler
tiler56131022tiler
truer54916642tru_er
tuber75420682tuber
tule45735872tule_
tules54532792tules
tuner56022682tuner
tuyer85414292tuyer
ulcer7310752_ulcer
urger64116472urger
user45023002_user
viler86324162viler
waler84229262waler
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 Limit538001741.72031279.1
3Display Results1741740.0463782.6
 (SQL Overall)1786911741.85996122.1
 
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.