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

166 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
slur4552515(None) 
blur66020531blur
slub65428031slub
slue45332191slue
slug55124641slug
slum65430511slum
slurb74116321slurb
slurp74014981slurp
slurs54123371slurs
slut45040591slut
sour45935891sour
spur65321191spur
alar46340072alar
alum65227612alum
blub85324872blub
blue65328462blue
bluer74918492bluer
blurb95214902blurb
blurs74619082blurs
blurt77625622blurt
bur55744692_bur
clour76617282clour
club85819472club
clue65324532clue
cur56841982_cur
dour56330432dour
flir76422202flir
flour84916452flour
flu66530212flu_
flub95721882flub
flue75329852flue
fluor84512772fluor
flus75626542flus
flux145617742flux
four76226862four
fur66637322_fur
gaur56723352gaur
glue55628492glue
gluer65116772gluer
glug66118012glug
glum75825102glum
glut56331292glut
hour75827312hour
knur85311972knur
lar37967532_lar
lour45430682lour
lug46138062_lug
lum55542932_lum
lure45142462_lure
lurk86624162_lurk
luv67125772_luv
lux106528772_lux
our36042892_our
plug74915992plug
plum85122102plum
plus66324832plus
pour611527472pour
pur56840552_pur
sau36356572sau_
saul45836522saul
saury84317222saury
scar66434202scar
scaur75814902scaur
scour75315532scour
scud76221282scud
scum85924522scum
scup84822382scup
scurf104719322scurf
scut65835542scut
sear47353842sear
seer45547042seer
ser36752402s_er
shlub105411742shlub
shul75823152shul
shun75122772shun
shut76137582shut
sieur5911892sieur
sir35746672s_ir
skua86113152skua
slab67133762slab
slag55934352slag
slam67737972slam
slap66434042slap
slat46959022slat
slaw77930712slaw
slay76436382slay
sled55334372sled
slew76228232slew
slid55828982slid
slier54827242slier
slim66631952slim
slip67031732slip
slit46250102slit
slob66029422slob
sloe45534952sloe
slog56728272slog
slop66533872slop
slot46049822slot
slow77729492slow
slubs74719532slubs
slued64220512slued
slues54527172slues
sluff114016812sluff
slugs64618562slugs
slump94816632slump
slums74623432slums
slung65117832slung
slunk95016302slunk
slurbs8439742slurbs
slurps84410002slurps
slurry9378592slurry
slush85316572slush
sluts54523982sluts
sly66228562sl_y
slyer85515122slyer
smug75815262smug
smut66629782smut
snub65320762snub
snug55218692snug
soar46838672soar
solar55927342solar
solum74717602solum
solus54726982solus
sou37853692sou_
souk86127172souk
soul46435712soul
soup66232912soup
sours55230502sours
sous46947212sous
spar65433302spar
spud75818492spud
spue66025522spue
spun66221462spun
spurn74815452spurn
spurs74621522spurs
spurt77227982spurt
star48037762star
stir45723242stir
stour54916742stour
stub66221842stub
stud56220092stud
stum65526012stum
stun45623452stun
sturt56028962sturt
sub55445552s_ub
sue35651462s_ue
suer45334032suer
suk75632972s_uk
sulfur937912sulfur
sulk85326652sulk
sulu45128422sulu
sulus54821882sulus
sum56346012s_um
sun37149032s_un
sup57041942s_up
suq126228992s_uq
sura45740292s_ura
surd56433812s_urd
sure45447412s_ure
surf76039312s_urf
swum96416822swum
tour45530372tour
ulu36028702ulu_
ulus45622562ulus
waur76819902waur
your78623432your

Search took 3 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 Limit298721661.93615429.8
3Display Results1661660.1261317.5
 (SQL Overall)1786911662.13883578.6
 
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.