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

202 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
spue6602552(None) 
slue45332191slue
spae65034321spae
sprue74717631sprue
spud75818491spud
spued84918471spued
spues75025381spues
spume95817311spume
spun66221461spun
spur65321191spur
sue35651461s_ue
supe65932761supe
ague55725922ague
ape57251182ap_e
apse67725382apse
blue65328462blue
clue65324532clue
cue57544182_cue
due45249862_due
dupe76630602dupe
epee64628502epee
flue75329852flue
glue55628492glue
grue55825712grue
hue66642302_hue
issue559212issue
jupe134921002jupe
kue76631862_kue
moue65835572moue
ope56845242op_e
opus66420592opus
pe47649032_p_e
pee56066512_pee
pie55457402_pie
pub76037692_pub
puce85127882_puce
pud65836652_pud
pug65337182_pug
puke105025462_puke
pul56138062_pul
pule65040952_pule
pun58846512_pun
pup76339882_pup
pur56840552_pur
pure65543332_pure
pus55547842_pus
put55759072_put
pye86432502_pye
roue45941742roue
rue35549262_rue
sabe66140572sabe
sade55544472sade
sae38365182s_ae
safe75930952safe
sage55044592sage
sake85244962sake
sale44959702sale
same65245642same
sane45954342sane
sate45556102sate
sau36356572sau_
sauce75121652sauce
saul45836522saul
saute55028082saute
save75741362save
scud76221282scud
scum85924522scum
scup84822382scup
scut65835542scut
scute75520942scute
see35772262s_ee
segue6314412segue
seme65836652seme
sene46848052sene
sere46153472sere
she66837692s_he
shoe75933442shoe
shul75823152shul
shun75122772shun
shut76137592shut
shute84520352shute
sice65545592sice
side55444482side
sike87138782sike
sine46560622sine
sipe67341042sipe
sire46150412sire
site47052412site
size135630962size
skee85431472skee
skua86113152skua
sloe45534952sloe
slub65428032slub
slued64220512slued
slues54527172slues
slug55124642slug
slum65430512slum
slur45525152slur
slut45040592slut
smug75815262smug
smut66629782smut
snub65320762snub
snug55218692snug
snye77115492snye
soke85436262soke
sole46053672sole
some66040382some
sone46649982sone
sore47059532sore
sou37853692sou_
souk86127172souk
soul46435712soul
soup66232912soup
sour45935892sour
sous46947212sous
souse56530772souse
spa55730812sp_a
space95325672space
spade84423322spade
spaed85522272spaed
spaes76029972spaes
spake114322742spake
spale74929212spale
spam85930042spam
span65234662span
spar65433302spar
spare75135562spare
spas67036722spas
spat66548522spat
spate74731582spate
spay96631662spay
spaz155626162spaz
spec85821972spec
sped76031492sped
speed85526622speed
speel74420762speel
speer74623902speer
spew95421872spew
spic85227432spic
spice95528812spice
spied85427712spied
spiel74623912spiel
spier75728032spier
spies76037622spies
spik105419712spik
spike114922842spike
spile75230082spile
spin66231302spin
spine76534422spine
spire75828692spire
spit65545082spit
spite75430662spite
spiv95917792spiv
spode84617702spode
spoke114818662spoke
spore75428592spore
spot65540692spot
spouse84112512spouse
spout75029632spout
spree74830862spree
spruce103910872spruce
sprues84515762sprues
sprug85313892sprug
spry96819122spry
spuds85113672spuds
spumed114711542spumed
spumes1021314882spumes
spumy124610362spumy
spunk114513402spunk
spurge93711322spurge
spurn74815452spurn
spurs74621522spurs
spurt77227982spurt
sputa74612962sputa
spy86023742sp_y
squeg1588032squeg
stub66221842stub
stud56220092stud
stum65526022stum
stun45623452stun
stupe75217752stupe
stye76218972stye
sub55445552s_ub
sued56537932s_ued
suer45334032s_uer
sues46247652s_ues
suet46754822s_uet
suk75632972s_uk
sum56346012s_um
sun37149032s_un
sup57041942s_up
super74924482super
supes75628302supes
sups64834432sups
suq126228992s_uq
sure45447412sure
swum96416822swum
syce95820282syce
syke115420562syke
syne75725762syne
true46725852true
usque14137732usque

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 Limit298722020.93631914.5
3Display Results2022020.0464391.3
 (SQL Overall)1786912021.058168895.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.