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

146 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
spang8491973(None) 
pang75336291_pang
sang55441231s_ang
slang66324021slang
span65234661span_
spank115919571spank
spans74528731spans
sprang95713521sprang
stang66424681stang
swang95519721swang
alang66023512alang
aping87327232aping
bang74837002_bang
bhang115512922bhang
chang115418562chang
clang86019312clang
dang65131542_dang
fang85432552_fang
gang66031972_gang
hang85535552_hang
kiang104811352kiang
lang56637382_lang
liang64914412liang
oping86322412oping
orang65119942orang
pan58466452_pan_
pane64950292_pane
panga85323532_panga
pangs84628662_pangs
pans65855732_pans
pant66061262_pant
ping75943592_ping
pong76231142_pong
prang84820322prang
pung75429632_pung
rang56939162_rang
sag46163402s_a_g
sand55338472s_and
sane45954342s_ane
sanga66023792s_anga
sangh95517452s_angh
sank85236832s_ank
sans45153362s_ans
satang75711562satang
scag76626892sca_g
scan65530452scan_
scans74625102scans
scant79735072scant
shag86430562sha_g
shank125422192shank
sing57544172s_ing
siping94220632siping
skag96321512ska_g
skank84415582skank
slag55934352sla_g
slangs75615342slangs
slangy105411392slangy
slank95822772slank
slant55238702slant
sling66028802sling
slung65117832slung
snag55827872sna_g
song55133672s_ong
spa55730812spa__
space95325672space
spacing123614492spacing
spacy125415622spacy
spade84423322spade
spading113114382spading
spado83713702spado
spae65034322spa_e
spaed85522272spaed
spaeing103413542spaeing
spaes76029972spaes
spahi10311142spahi
spail74921552spail
spait75631602spait
spake114322742spake
spale74929212spale
spall74919302spall
spam85930042spa_m
spams94922192spams
spangle1038402spangle
spangly1336472spangly
spanks124514122spanks
spar65433302spa_r
spare75135562spare
sparge94216052sparge
sparing104823872sparing
spark114920892spark
spars75431542spars
spas67036722spa_s
spasm94514172spasm
spat66548522spa_t
spate74731582spate
spats75031382spats
spawn107811712spawn
spawns11577922spawns
spay96631662spa_y
spaying133014622spaying
spays105520512spays
spaz155626162spa_z
spazz155811132spazz
spean74620512spean_
speans85417142speans
spend85619332spend
spent75532832spent
spin66231302spin_
spine76534422spine
spins75327982spins
spiny104921302spiny
sponge939662sponge
spongy1236742spongy
sprag86418692sprag
sprangs104610052sprangs
sprig85617742sprig
spring94526012spring
sprug85313892sprug
sprung94610032sprung
spuing94313362spuing
spun66221462spun_
spunk114513402spunk
spying123913252spying
stag57332002sta_g
staig65519642staig
stand65923282stand
stane55933002stane
stangs75018162stangs
stank95823302stank
sting65330242sting
strang75718312strang
stung65417152stung
suing65026362suing
sung55832172s_ung
swag87526732swa_g
swan76631312swan_
swank125318232swank
swans84625012swans
swing96124842swing
swung95610562swung
tang56138672_tang
twang94511852twang
vang84926042_vang
whang124813382whang
wrang94716112wrang
yang85626072_yang

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 Filter178691538000.313570897.8
2DLD Change Limit538001462.15624953.6
3Display Results1461460.0304866.7
 (SQL Overall)1786911462.49971505.0
 
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.