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

134 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
smart7583409(None) 
mart66865981_mart
scart76139771scart
smalt74729331smalt
smarm95517601smarm
smarts86218001smarts
smarty115013791smarty
start55642311start
swart86234641swart
amort75832202amort
apart74330672apart
art38679142__art
boart78835932boart
cart66570342_cart
chart105038282chart
dart55857872_dart
fart76860562_fart
hart76865772_hart
heart85440742heart
imaret81121232imaret
impart102715142impart
kart86750822_kart
lyart85121882lyart
malt66254812_malt
mar57965952_mar_
mara67444582_mara
marc87034632_marc
mare64759332_mare
mark105138062_mark
marl66341622_marl
mars66261872_mars
marts77442232_marts
mast65959962_mast
mat58083942_ma_t
matt65752662_matt
maut65448452_maut
mort66758832_mort
part65967462_part
peart76440752peart
quart144027852quart
salt45758522s_alt
samara8313852samara
sard55344242s_ard
sari45444042s_ari
sark84938972s_ark
sat36288482s_a_t
scant79735072scant
scar66434202scar_
scare75334462scare
scarf105427142scarf
scarp95724102scarp
scars75433532scars
scarts85321492scarts
scary105222592scary
scat65848372sca_t
scatt76030092scatt
sear47353842sear_
sears54744912sears
seat47575562sea_t
shaft115725272shaft
shalt85534492shalt
shard96125962shard
share86437082share
shark126225022shark
sharn84823702sharn
sharp104922532sharp
shat76456602sha_t
shirt84533902shirt
short85040532short
simar74920812simar_
simars84916932simars
skat87037902ska_t
skirt95624672skirt
skort94925642skort
slant55238702slant
slat46959022sla_t
smack134615452smack
small74016262small
smalti84111192smalti
smalto84410282smalto
smalts85214892smalts
smarms105712532smarms
smarmy13629352smarmy
smarted105012612smarted
smarten9348862smarten
smarter94113132smarter
smartie9310172smartie
smartly12497432smartly
smash104814432smash
smaze165012932smaze
smear74416392smear_
smears84714432smears
smeary114110802smeary
smelt74726782smelt
smerk115412722smerk
smirk116612752smirk
smit65138412sm_it
smolt74824162smolt
smut66629782sm_ut
snare54429982snare
snarf86525422snarf
snark95419942snark
snarl54921082snarl
snort54833752snort
soar46838672soar_
soars54732512soars
sort46264812s_ort
spait75631602spait
spar65433302spar_
spare75135562spare
spark114920892spark
spars75431542spars
spat66548522spa_t
spirt75032952spirt
sport75935982sport
sprat76635972sprat
spurt77227982spurt
star48037762star_
stare54440262stare
stark95425622stark
stars55836572stars
starts65423122starts
stat47352692sta_t
sturt56028962sturt
sward94221462sward
sware85828212sware
swarf115324652swarf
swarm106218842swarm
swarth126012082swarth
swarty125812382swarty
swat77244442swa_t
tart47566182_tart
unsmart939602unsmart
wart77866082_wart

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.296603685.8
2DLD Change Limit538001341.72031279.1
3Display Results1341340.0304466.7
 (SQL Overall)1786911342.04687336.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.