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

292 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
rule4993842(None) 
mule65236971mule
pule65040951pule
rale45050561rale
rile45650531rile
role45851821role
rube65532011rube
ruble74521251ruble
rude55632781rude
rue35549261ru_e
ruled65822521ruled
ruler54923341ruler
rules55234251rules
ruly76323141ruly
rune45236291rune
ruse45938931ruse
tule45735871tule
yule75725141yule
able66340532able
ale36572342_ale
argle65421562argle
auld54125362auld
axle116424602axle
bale66353842bale
bile66147172bile
blue65328462blue
bole66448692bole
boule74828042boule
brume95817982brume
brute75321782brute
bugle84721942bugle
bulb85626692bulb
bulge86419872bulge
bulk105426152bulk
bull65634872bull
bute66739672bute
butle75023102butle
clue65324532clue
cole66956112cole
crude86018572crude
cruel74815902cruel
cruse75726102cruse
cube85830212cube
cue57544182cu_e
cuke105824982cuke
culet76040342culet
culex144613932culex
cull65929642cull
culm85822382culm
cult66541152cult
cure66149122cure
curule83614122curule
cute66440452cute
dale55643982dale
dele56843082dele
dole56550002dole
drupe85012992drupe
druse64817662druse
duce76933502duce
dude65629662dude
due45249862du_e
duel56729702duel
duke95628102duke
dull56430442dull
dulse65415042dulse
duly85323032duly
dune56137582dune
dupe76630602dupe
duple85315862duple
dure56341812dure
ferule93413202ferule
file75446642file
flue75329852flue
fuel76824732fuel
fugle94915542fugle
full75229152full
fume96727632fume
fuse76429992fuse
fuze166422372fuze
gale56347322gale
glue55628492glue
grue55825712gru_e
gruel66014742gruel
grume86218162grume
gude65423332gude
guile64521132guile
gul45832792gul_
gules64831042gules
gulf84929422gulf
gull54828452gull
gulp75521362gulp
guls55930852guls
hale76052832hale
hole77553392hole
hue66642302hu_e
huge86321652huge
hula74923752hula
hulk115321612hulk
hull75428782hull
idle55423762idle
isle45121702isle
jole117233822jole
joule124918202joule
jube136322782jube
juke154721662juke
julep14310532julep
jupe134921002jupe
jute115327892jute
kale86533752kale
kue76631862ku_e
kune85424572kune
lube64731562lube
luce65132572luce
lude55331642lude
luge55531642luge
lull44225762lull
lulu44122882lulu
lune47140492lune
lure45142462lure
lute46341012lute
luxe115222692luxe
male66052292male
mile66352562mile
mole66251832mole
muled85824432muled
mules75034292mules
muley104819282muley
mull65128802mull
mure65941332mure
muse67136032muse
mute65136872mute
nude56626272nude
nuke85920752nuke
null45125312null
ogle56325052ogle
ole37155212_ole
orle45630462orle
ovule839492ovule
pale66055012pale
pele65539552pele
pile65649692pile
pole65951302pole
prole74527792prole
prude84615972prude
prune75119632prune
puce85127882puce
puke105025462puke
pul56138062pul_
pula65129372pula
puled84926522puled
puler74826622puler
pules74538812pules
puli65527622puli
pull64731662pull
pulp84825352pulp
puls65437562puls
pulse74219972pulse
pure65543332pure
quale143617852quale
race66746262race
rage55742352rage
rake84841572rake
rales54947492rales
rape65041632rape
rare45348432rare
rase46149982rase
rate45458762rate
rave75542092rave
raze135235432raze
re26153742r__e
rede55037662rede
ree37974072r_ee
reel45240532reel
relet54749822relet
rely75428952rely
rete44944132rete
reuse56025362reuse
rice64942912rice
ride55945122ride
riel46432382riel
rife74632322rife
rifle85518332rifle
riled65833252riled
riles55343642riles
riley84420582riley
rill45140902rill
rille55728732rille
rime65138882rime
ripe66038922ripe
rise45945232rise
rite45849452rite
rive75537722rive
robe65335642robe
roble75223022roble
rode55844302rode
roe36861072r_oe
roles56747982roles
rolf75134872rolf
roll46331652roll
rope65542912rope
rose46148902rose
rote46249022rote
rouble83913312rouble
roue45941742roue
rouge65423442rouge
rouse56634702rouse
route55132072route
rove75136982rove
rub56342822ru_b
rubble104315672rubble
rubel75416832rubel
rubes74928412rubes
rubles83921702rubles
rubs66133492rubs
ruby97819942ruby
ruche104216762ruche
ruck104728332ruck
ruckle124414582ruckle
rudd65917472rudd
ruddle83414202ruddle
ruder65320542ruder
rued55729792rued
ruer46127562ruer
rues46044482rues
ruff105127652ruff
ruffe114713812ruffe
ruffle124111672ruffle
rug46039152ru_g
ruga56121232ruga
rugae65114762rugae
rugs56033682rugs
ruin47430512ruin
rulers64317092rulers
rulier65016352rulier
rum56644642ru_m
rumble103718812rumble
rumen74419502rumen
rump86729082rump
rumple103913012rumple
rums64833472rums
run36244982ru_n
rundle73214232rundle
runes55530222runes
rung56429972rung
runkle103611542runkle
runlet63821412runlet
runs46438072runs
runt46647982runt
rupee7321282rupee
ruses56136582ruses
rush76628182rush
rusk85823312rusk
rust45544912rust
rustle63615412rustle
rut35560522ru_t
ruth76825992ruth
rutile65217682rutile
ruts44541492ruts
rye66032542r_ye
ryke115616402ryke
sale44959702sale
slue45332192slue
sole46053672sole
sue35651462su_e
sulk85326652sulk
sulu45128422sulu
supe65932762supe
sure45447412sure
tale46154162tale
tele45040872tele
tile45451442tile
tole46052902tole
truce75118692truce
true46725852tru_e
trull54012672trull
truly84111552truly
tube65828662tube
tules54532792tules
tulle54019932tulle
tune45635862tune
uke75727292_uke
ulu36028702_ulu
urge54722412urge
use36835162_use
ute35335882_ute
vale74937342vale
vile76139802vile
vole75236982vole
wale74546432wale
wile75944372wile
wyle105519382wyle
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 Filter178691298720.0762351197.4
2DLD Change Limit298722921.34322242.7
3Display Results2922920.1102654.5
 (SQL Overall)1786912921.529116867.9
 
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.