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

300 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
gules6483104(None) 
gales65442481gales
glues65125681glues
gudes74520811gudes
guiles73919281guiles
gulfs94915301gulfs
gulls65222981gulls
gulps84715071gulps
guls55930851gul_s
mules75034291mules
pules74538811pules
rules55234251rules
tules54532791tules
yules84521581yules
ables75935542ables
agues64919052agu_es
ales47067102_ales
arles56735742arles
aures55137092aures
axles125219472axles
bales76250082bales
biles75542142biles
blues75127042blues
boles75448602boles
boules84925972boules
bugles94822442bugles
bulbs96016932bulbs
bulges95919322bulges
bulks115920612bulks
bulls75629572bulls
buses75936012buses
butes714535872butes
butles84423912butles
caules85927252caules
clues74623032clues
coles76055062coles
cubes95028162cubes
cues65438982cu_es
cukes115422092cukes
culet76040342culet
culets85518512culets
culex144613932culex
culls75425812culls
culms95314192culms
cults75022552cults
cures75645432cures
cutes79438312cutes
dales66439742dales
deles65139252deles
doles67843752doles
duces86327472duces
dudes75424372dudes
duels65619232duels
dues56045502du_es
dukes105023472dukes
dulls64523742dulls
dulse65415042dulse
dulses73913652dulses
dunes65332172dunes
dupes86425932dupes
dures65635922dures
files85441272files
flues84626922flues
fuels87117352fuels
fugles104715782fugles
fulls84623522fulls
fumes105224702fumes
fuses85628422fuses
fuzes175120222fuzes
gables94222332gables
gaes56348032g_aes
gages74529972gages
galas65731642galas
gale56347322gale_
galea64722932galea
galeas74618502galeas
galls64729322galls
gals57946502gal_s
games86238552games
gapes86030822gapes
gases65633992gases
gates65939502gates
gauges85915992gauges
gaults74112782gaults
gauzes164710632gauzes
gazes155425912gazes
gees55647882g_ees
gelds75118342gelds
gelee63626982gelee
gelees74116262gelees
gels56836102gel_s
gelts65924612gelts
genes65133092genes
ghees95215552ghees
gibes84422522gibes
gies55641422g_ies
gilds75417522gilds
gills64728192gills
gilts64924262gilts
gites65630182gites
gives95324872gives
gled65631142g_led
gleds75417892g_leds
glee55239062g_lee
glees65027592glees
gleg66219802g_leg
glen56027202g_len
glens66519852g_lens
gley85724652g_ley
gleys96514852g_leys
glue55628492glue_
glued75118362glued
gluer65116772gluer
gluers75011152gluers
gluey95715262gluey
glugs75214282glugs
glumes94516812glumes
glums84621422glums
glutes74517672glutes
gluts66120132gluts
goes55644092g_oes
golds75421312golds
golem8416112golem
golems939322golems
golfs95616102golfs
gores65740372gores
gouges86318692gouges
goxes135018262goxes
grees65132472grees
gruels73910152gruels
grues65721962grues
grumes94415552grumes
guans64419442guans
guars65021042guars
gucks123917302gucks
gude65423332gude_
guess64213362guess
guest65225922gu_est
guffs124414822guffs
guggles103410542guggles
guglet84018222guglet
guglets9369692guglets
guides84118282guides
guids75516152guids
guilds8388352guilds
guile64521132guile_
guiled84315382guiled
guilts74111232guilts
guise64717712guise
guises74216312guises
gul45832792gul__
gulag7310822gulag
gulags837542gulags
gular6314832gular
gulch113810602gulch
gulches13398102gulches
gulden8328762gulden
guldens9356572guldens
gulf84929422gul_f
gulfed114810012gulfed
gulfy124612002gulfy
gull54828452gul_l
gulled84521372gulled
gullet74924832gullet
gullets84013712gullets
gulley104213162gulley
gulleys11438522gulleys
gullies84717312gullies
gully94020682gully
gulp75521362gul_p
gulped104610372gulped
gulper93410212gulper
gulpers10299002gulpers
gulpy114612762gulpy
gumless10228272gumless
gums75030942gu_ms
gunks104517722gunks
gunless8299632gunless
guns55533482gu_ns
gurges84716862gurges
gurgles94312872gurgles
gurus64318192gurus
gushes104719032gushes
gusts65722792gusts
gutless82610712gutless
guts56637252gu_ts
guttles83011932guttles
guvs85816812gu_vs
guyed1049892guyed
guys85019642gu_ys
guzzles16328042guzzles
gybes115012722gybes
gyres94820322gyres
gyves125711552gyves
hales85449842hales
holes84748652holes
hues75235232hu_es
hulas84920882hulas
hulks125715482hulks
hulls84923562hulls
idles66720122idles
isles54220562isles
joles125230832joles
joules134116822joules
jubes145420742jubes
jukes165319102jukes
julep14310532julep
juleps1535622juleps
jupes145218552jupes
jutes125125132jutes
kales95730982kales
kues86426772ku_es
les35663072__les
ligules82210912ligules
lubes74727992lubes
luces75528432luces
ludes65728852ludes
lues45943552lu_es
luges65928752luges
lulls54119652lulls
lulus54315162lulus
lunes55337772lunes
lures56138532lures
lutes55836662lutes
luxes124921502luxes
males75049792males
miles74645072miles
moles74747922moles
mule65236972mule_
muled85824432muled
muley104819282muley
muleys11409642muleys
mulls75124152mulls
mures75937212mures
muses75134302muses
mutes75033782mutes
nudes64723292nudes
nukes95418122nukes
nulls55019982nulls
ogles65223182ogles
oles46453472_oles
orles55326212orles
ovules938222ovules
pales75753802pales
peles75738082peles
piles74742612piles
poles75351002poles
pubes94423402pubes
puces94924632puces
pukes114523022pukes
pule65040952pule_
puled84926522puled
puler74826622puler
pulers83820282pulers
pulis74225602pulis
pulls74425052pulls
pulps95116482pulps
puls65437562pul_s
pulse74219972pulse
pulses83818662pulses
puses75532202puses
rales54947492rales
riles55343642riles
roles56747982roles
rubes74928412rubes
rubles83921702rubles
rues46044482ru_es
rule49938422rule_
ruled65822522ruled
ruler54923342ruler
rulers64317092rulers
runes55530222runes
ruses56136582ruses
sales56055592sales
slues54527172slues
soles55547922soles
sues46247652su_es
sulks94818462sulks
sulus54821882sulus
supes75628302supes
tales55451372tales
teles54536002teles
tiles55542102tiles
toles55147132toles
tubes74826452tubes
tule45735872tule_
tulles63218892tulles
tunes55332192tunes
tuxes124316042tuxes
uglies7412322uglies
ukes86122812_ukes
ulus45622562_ulus
uses44931112_uses
utes45930882_utes
vales85434262vales
voles86234042voles
wales86142832wales
wiles85437872wiles
wyles114615322wyles
yule75725142yule_

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 Limit538003001.69031834.3
3Display Results3003000.0933225.8
 (SQL Overall)1786913001.87695251.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.