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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

169 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
stemmier124525(None) 
steamier1048301steamier
stemmer113210181stemm_er
gemmier12337382_gemmier
scummier1445082scummier
seamier93114632s_eamier
seemlier1035192seemlier
slummier1235472slummier
stammer116013342stamm_er
steadier937312steadier
steamer93313092steam_er
steelier839182steelier
stemmed12278152stemm_ed
stemmers12378442stemm_ers
stemmery15334692stemm_ery
stemmiest1335142stemmiest
stemming13408202stemming
stormier1036102stormier
streamier1155762streamier
stumpier1255882stumpier
swimmier15174312swimmier
atelier7311623ate_lier
beamier113411943_beamier
chummier1734513chummier
clammier1435843clammier
creamier12319063creamier
crummier1435603crummier
dreamier11287293dreamier
elmier839813__elmier
emmer94314463__emm_er
gammier123711193_gammier
germier10309543_germier
gleamier1144913gleamier
gremmie1264383gremmie_
gremmies1355993gremmies
gummier12349473_gummier
hammier143510653_hammier
hemmer134112643_hemm_er
hempier14319003_hempier
itemizer19104453itemizer
jammier18408023_jammier
jemmied19294483_jemmied
jemmies18318333_jemmies
plummier1434123plummier
premier113515633pre_mier
rammier112811023_rammier
rheumier1342513rheumier
rummier11309563_rummier
scammer133611973scamm_er
scummer13398753scumm_er
seamer84223613s_eam_er
sedgier9399053s_edgier
seedier83513633s_eedier
seemer84418043s_eem_er
seepier92912013s_eepier
sexier13310683s_e_xier
shammer144613143shamm_er
shammied16265543shammied
shammies15259683shammies
sheenier11167423sheenier
shellier1138393shellier
shelvier1464913shelvier
shimmer143310873shimm_er
shimmied16294983shimmied
shimmies15287803shimmies
simmer104115353s_imm_er
skimmer15327533skimm_er
skimpier1634293skimpier
slammer113913033slamm_er
sleazier1735123sleazier
sleekier1245573sleekier
sleepier1036783sleepier
sleetier837883sleetier
slimier93212013s_limier
slimmer114211343slimm_er
slimsier1085213slimsier
slummer113711203slumm_er
smarmier1235033smarmier
smearier1036953smearier
smellier1036793smellier
sneakier1245143sneakier
sneerier878103sneerier
sneezier1774333sneezier
spammer133410433spamm_er
speedier1146623speedier
spendier1147143spendier
spumier1137903s_pumier
staggier10167513staggier
stagier83513443st_agier
stalkier1257073stalkier
stammel11607533stamm_el
stammerer1344063stammerer
stammers123611523stamm_ers
stamper113714403st_amper
starrier8279463starrier
steadied1036563steadied
steadiers1035083steadiers
steadies9311123steadies
stealer72913973ste_aler
steamed103712143steam_ed
steamers103410873steam_ers
steamiest1138403steamiest
steamily1335803steamily
steaming114013213steaming
steelie7310213steelie_
steelies8312553steelies
steeper93812773ste_eper
steer55423863ste___er
steerer73113633ste_erer
stemlike1436723stemlike
stemma10328133stemm__a
stemmas11256973stemm_as
stemmata1244213stemmata
stemmeries1445173stemmeries
stemmy13417033stemm__y
stemware1344883stemware
stenchier1445333stenchier
stenciler1143783stenciler
stepper113010853ste_pper
sterner7411913ste_rner
stickier14229763stickier
stillier868823stillier
stimied10310623st_imied
stimies9316563st_imies
stingier9279123stingier
stinkier12278543stinkier
stockier14217253stockier
stodgier1034223stodgier
stomper114111233st_omper
stonier72013793st_onier
strawier1137493strawier
streakier1334843streakier
streamer10239513stream_er
stripier1058863stripier
strummer1234783strummer
stubbier1235353stubbier
studier82510053st_udier
studlier935473studlier
stuffier14336623stuffier
stumbler1235813stumbler
stummed12348553stumm_ed
stumming13347673stumming
stumper113610093st_umper
sturdier9216963sturdier
stymie1137623st_ymie_
stymied1335663st_ymied
stymies1239213st_ymies
summer104017713s_umm_er
swampier1544593swampier
sweatier1147033sweatier
sweepier1355493sweepier
swimmer14297653swimm_er
tammie104212693_tammie_
tammies113814683_tammies
tearier73815613_tearier
techier1269243_techier
teemer85515743_teem_er
teenier72611143_teenier
temper103914093_te_mper
tempter11358213_tempter
tentier73815923_tentier
termer85717253_term_er
terrier73414963_terrier
testier74015643_testier
thymier1534393_thymier
tommies113812983_tommies
tummies113012033_tummies
tummler11266613_tummler
yummier14306843_yummier

Search took 8 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 Filter1786911461620.406440125.6
2DLD Change Limit1461621697.33019940.2
3Display Results1691690.0762223.7
 (SQL Overall)1786911697.81222873.9
 
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.