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

231 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
stormier103610(None) 
smarmier1235032smarmier
sorrier72313732s_orrier
sportier102010052sportier
starrier8279462starrier
steamier1048302steamier
stemmier1245252stemmier
stockier14217252stockier
stodgier1034222stodgier
stomper114111232sto_mper
stonier72013792sto_nier
storer64721672stor__er
storied8515162stor_ied
stories7324272stor_ies
stormed1039042storm_ed
stormiest1137002stormiest
stormily1345242stormily
storming11209422storming
sturdier9216962sturdier
wormier12278762_wormier
atomies93918363ato_mies
atomiser10268153ato_miser
atomizer19298533ato_mizer
barmier114313043_barmier
bloomier1275783bloomier
boomier113312183_boomier
broomier1236873broomier
chromier1538033chromier
corkier133114303_corkier
cornier93017093_cornier
doomier103610123_doomier
dorkier122810023_dorkier
dormer94415903_dorm_er
dormie9312623_dormie_
foamier12339003_foamier
forkier144311593_forkier
former114221403_form_er
germier10309543_germier
gloomier1135093gloomier
gorier73719373_gor_ier
gorsier83811073_gorsier
homier116416993_ho_mier
hornier103012463_hornier
horsier103013243_horsier
loamier9349163_loamier
lorimer937753_lorimer
moorier93113073moor_ier
orbier839993__orbier
ormer75218373__orm_er
ostomies10310583osto_mies
porkier133712343_porkier
pornier93413133_pornier
roomier93812243_roomier
sarkier113413313s_arkier
savorier1136643savor_ier
scarier94017873scar_ier
scarrier10298453scarrier
scorcher15196793scorcher
scorer84818263scor__er
scorifier1445413scorifier
scorner9259763scor_ner
scummier1445083scummier
scurfier13267053scurfier
scurvier13255883scurvier
seamier93114633s_eamier
shirtier1137943shirtier
shoalier1137073shoalier
shoddier1334213shoddier
shorter103515503shor_ter
shortie10411343shortie_
shorties11414583shorties
showier1339103sho_wier
slimier93212013s_limier
slobbier1254633slobbier
sloppier1255713sloppier
sloshier1135283sloshier
slummier1235473slummier
smirkier1444433smirkier
smoggier1243973smoggier
smokier1356703smo_kier
snarkier12336513snarkier
snarlier8278183snarlier
snobbier1234633snobbier
snoopier10177273snoopier
snootier8278383snootier
snoozier17185193snoozier
snorer64316763snor__er
snorter74412663snor_ter
snottier8217383snottier
snoutier8206973snoutier
snowier1038793sno_wier
soapier93411713s_oapier
soggier93410883s_oggier
soldier82812153s_oldier
somber103714003s_o_mber
sonsier7711743s_onsier
sootier73916613s_ootier
soppier112711583s_oppier
sorer56236593s_or__er
sorner64720393s_or_ner
sorter64425093s_or_ter
sortie63621993s_ortie_
sortied83314103s_ortied
sorties74126403s_orties
soupier93111753s_oupier
sparkier14298033sparkier
sparrier10329143sparrier
spirier93214073spir_ier
spongier1135743spongier
spookier14175493spookier
spoonier10167653spoonier
sporter93616553spor_ter
spottier10207313spottier
sprier84119063s_pr_ier
spumier1137903s_pumier
spurrier10297693spurrier
squirmier2042853squirmier
staggier10167513staggier
stagier83513443st_agier
stalkier1257073stalkier
stammer116013343st_ammer
stamper113714403st_amper
starchier1436643starchier
starer64027363star__er
starker114114693star_ker
starter73817883star_ter
startler8248793startler
starver104611993star_ver
steadier937313steadier
steamer93313093steam_er
steelier839193steelier
stemmer113210183st_emmer
sterner7411913ster_ner
stickier14229763stickier
stillier868823stillier
stimied10310623st_imied
stimies9316563st_imies
stingier9279123stingier
stinkier12278543stinkier
stirrer7338233stir_rer
stocker133713083sto_cker
stogie7311323sto_gie_
stogies8413693sto_gies
stoker104417623sto__ker
stolider936603stolider
stomped124110533sto_mped
stompers123610043sto_mpers
stoner65823203sto__ner
stooker113811733sto_oker
stoolie739723stoolie_
stoolies8311083stoolies
stooper93813193sto_oper
stoper84320103sto__per
stopover1344063stopover
stopper113012603sto_pper
storage8310473storage_
storages9311103storages
storaxes1536883storaxes
store56333813stor__e_
stored75524213stor__ed
storers75018683stor__ers
stores65533663stor__es
storey95217613stor__ey
storeyed1234643storeyed
storing83921123stor_ing
storm76520403storm___
storminess1245213storminess
storms85814633storm__s
stormy115510733storm__y
storying12249673storying
stourie7469353stourie_
stouter74012053sto_uter
stover94115643sto__ver
strafer103912463st_rafer
strainer8512223st_rainer
straiter8311783st_raiter
strawier1137493strawier
strayer104312503st_rayer
streamier1155763streamier
strewer104310413st_rewer
strider84315723st_rider
striker113714173st_riker
striper94514793st_riper
stripier1058863stripier
striver104315203st_river
stroker114113523st_roker
stroller848183stroller
stronger9349693stronger
stropper1247763stropper
stroppier1364453stroppier
stroyer103510783st_royer
strummer1234783strummer
stubbier1235353stubbier
studier82510053st_udier
studlier935473studlier
stuffier14336623stuffier
stumper113610093st_umper
stumpier1255883stumpier
sturdied10215963sturdied
sturdies92110273sturdies
stymie1137623st_ymie_
stymied1335663st_ymied
stymies1239213st_ymies
surfier102613543s_urfier
surlier72915443s_urlier
surmiser1036763s_urmiser
swarmer1247803swarm_er
swimmier15174313swimmier
swirlier1135213swirlier
swoonier11185133swoonier
swoopier13175143swoopier
tardier859719993_tardier
tarrier74323173_tarrier
tarsier74119253_tarsier
tartier74123263_tartier
termer85717253_term_er
terrier73414963_terrier
thornier1135323thornier
thymier1534393_thymier
tommies113812983_tommies
tonier65520713_to_nier
torchier1337463_torchier
tories65435883_tor_ies
torquer16205323_torquer
torrider936173_torrider
trier54328533_t_r_ier
trimer85717153_t_rimer
turfier10249793_turfier
wordier112511213_wordier
wormer114514913_worm_er
worrier102311683_worrier

Search took 9 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.436409841.7
2DLD Change Limit1461622317.84318636.0
3Display Results2312310.0932483.9
 (SQL Overall)1786912318.37221343.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.