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 “smarm” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
smarm9551760(None) 
smarms105712531smarms
smarmy13629351smarmy
smart75834091smart
swarm106218841swarm
alarm76621422alarm
arm58449622__arm
aswarm11107912aswarm
barm86739602_barm
charm126124662charm
farm95934532_farm
harm95637792_harm
imam81718332ima_m
imaum9139642imaum
inarm7314422inarm
maim85831492_maim
malm85129982_malm
mar57965952_mar_
mara67444572_mara
marc87034632_marc
mare64759332_mare
mark105138062_mark
marl66341622_marl
mars66261872_mars
mart66865982_mart
rearm75923572rearm
samara8313852samara
sard55344242s_ard
sari45444042s_ari
sark84938972s_ark
scam85932352sca_m
scar66434202scar_
scare75334462scare
scarf105427142scarf
scarp95724102scarp
scars75433532scars
scart76139772scart
scary105222592scary
scram910621622scram
seam66645972sea_m
sear47353842sear_
sears54744912sears
sham96436362sha_m
shard96125962shard
share86437082share
shark126225022shark
sharn84823702sharn
sharp104922532sharp
shawm135316152shawm
simar74920812simar_
simars84916932simars
slam67737972sla_m
smack134615452smack
small74016262small
smalt74729332smalt
smarts86218002smarts
smarty115013792smarty
smash104814432smash
smaze165012932smaze
smear74416392smear_
smears84714432smears
smeary114110802smeary
smerk115412722smerk
smirk116612752smirk
snare54429982snare
snarf86525422snarf
snark95419942snark
snarl54921082snarl
soar46838672soar_
soars54732512soars
spam85930042spa_m
spar65433302spar_
spare75135562spare
spark114920892spark
spars75431542spars
spasm94514172spasm
sperm93216022sperm
star48037762star_
stare54440262stare
stark95425622stark
stars55836572stars
start55642312start
storm76520402storm
swam96329982swa_m
sward94221462sward
sware85828212sware
swarf115324652swarf
swarms116112172swarms
swart86234642swart
tharm105916642tharm
unarm7314452unarm
warm95935672_warm

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.300595636.7
2DLD Change Limit53800921.62333148.5
3Display Results92920.0165750.0
 (SQL Overall)178691921.93992156.3
 
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.