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

263 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
steamier104830(None) 
seamier93114631s_eamier
steadier937311steadier
steamer93313091steam_er
stemmier1245251stemmier
streamier1155761streamier
beamier113411942_beamier
creamier12319062creamier
dreamier11287292dreamier
gleamier1144912gleamier
seamer84223612s_eam_er
sleazier1735122sleazier
smearier1036952smearier
sneakier1245142sneakier
stagier83513442st_agier
stammer116013342st_ammer
stamper113714402st_amper
steadied1036562steadied
steadiers1035082steadiers
steadies9311122steadies
stealer72913982stea_ler
steamed103712142steam_ed
steamers103410872steam_ers
steamiest1138412steamiest
steamily1335802steamily
steaming114013212steaming
steelier839192steelier
stemmer113210182ste_mmer
stormier1036102stormier
strawier1137492strawier
streakier1334842streakier
streamer10239512stream_er
sweatier1147032sweatier
tearier73815612_tearier
atelier7311623ate_lier
beadier103513913_beadier
beakier134012163_beakier
blearier1037333blearier
creakier14328333creakier
creamer113714093cream_er
creasier103210193creasier
dreamer104110843dream_er
drearier9297923drearier
easier64218463__easier
elmier839813__elmier
flamier123112143_flamier
foamier12339003_foamier
freakier15246483freakier
gamier93617933__gamier
gemmier12337383_gemmier
germier10309543_germier
gleamer10328513gleam_er
greasier9298083greasier
headier113212953_headier
heavier13429423_heavier
itemizer19104453ite_mizer
leadier83212723_leadier
leafier10329833_leafier
leakier114010993_leakier
learier73415663_learier
leavier10319993_leavier
loamier9349163_loamier
mealier93015903_mealier
meatier93214613_meatier
metamer1139613metam_er
peakier134411443_peakier
peatier94017233_peatier
premier113515633pre_mier
queasier1734473queasier
queazier2642833queazier
readier83117423_readier
reamer84325213_ream_er
recamier1237603recamier
rheumier1342513rheumier
sagier73717163s__agier
samiel8313333s__amiel
scalier94316913s_calier
scammer133611973s_cammer
scamper134613163s_camper
scarier94017873s_carier
screamer12267883scream_er
scummier1445083scummier
sealer63928963s_ea_ler
seamed94823883s_eam_ed
seamen84518563s_eam_en
seamers94719433s_eam_ers
seamiest102715423s_eamiest
seaming103222113s_eaming
seamster1037143s_eamster
searer65432023s_ea_rer
seater64534163s_ea_ter
sedgier9399053s_edgier
seedier83513633s_eedier
seemer84418043s_eem_er
seemlier1035193seemlier
seepier92912013s_eepier
sexier13310683s_e_xier
shadier113111153s_hadier
shakier143411153s_hakier
shalier103116423s_halier
shammer144613143s_hammer
shearer104414683shea_rer
sheather1458233sheather
sheenier11167423sheenier
shellier1138393shellier
shelvier1464913shelvier
shoalier1137073shoalier
slammer113913033s_lammer
slatier74016813s_latier
sleekier1245573sleekier
sleepier1036783sleepier
sleetier837883sleetier
slimier93212013s_limier
slummier1235473slummier
smarmier1235033smarmier
smearer94110403smea_rer
smellier1036793smellier
snakier112810003s_nakier
sneaker112910453snea_ker
sneerier878103sneerier
sneezier1774333sneezier
soapier93411713s_oapier
spacier114011633s_pacier
spammer133410433s_pammer
speaker133311213spea_ker
spearer93913663spea_rer
speedier1146623speedier
spendier1147143spendier
spumier1137903s_pumier
squeakier2242903squeakier
stabber113610153st_abber
stabler94014933st_abler
stacker134416263st_acker
staffer13299093st_affer
stager74821343st_a_ger
stagger94212393st_agger
staggier10167513staggier
staider83912613st_aider
stainer73614923st_ainer
stair54719943st_a_i_r
staler64025823st_a_ler
stalker113912253st_alker
stalkier1257073stalkier
stamen84115943st_am_en
stamina9310793st_amina
stammel11607533st_ammel
stammers123611523st_ammers
stamped124812813st_amped
stampers124211603st_ampers
stander84316163st_ander
stapler93913633st_apler
starer64027363st_a_rer
starker114114693st_arker
starrier8279463starrier
starter73817883st_arter
starver104611993st_arver
stater64427563st_a_ter
stayer94516483st_a_yer
steaded92811673stea_ded
steadiest1038523steadiest
steadily1236213steadily
steading103613593steading
stealers83412213stea_lers
stealing93416603stealing
stealthier1342863stealthier
steam76322933steam___
steamered1244913steamered
steamfitter1651223steamfitter
steaminess1236773steaminess
steams84916903steam__s
steamy115112373steam__y
stearic939423steari_c
stearin7312003steari_n
stearine8311903stearine
stearines9311283stearines
stearins8312143stearins
steatite8310583steatite
steatites939843steatites
steelie7310213steelie_
steelies8312553steelies
steeper93812773ste_eper
steer55423863ste___er
steerer73113633ste_erer
stemmed12278153ste_mmed
stemmers12378443ste_mmers
stemmery15334693ste_mmery
stemmiest1335143stemmiest
stemming13408203stemming
stenchier1445333stenchier
stenciler1143783stenciler
stepper113010853ste_pper
sterner7411913ste_rner
stickier14229763stickier
stillier868823stillier
stimied10310623st_imied
stimies9316563st_imies
stingier9279123stingier
stinkier12278543stinkier
stockier14217253stockier
stodgier1034223stodgier
stomper114111233st_omper
stonier72013793st_onier
strafer103912463stra_fer
strainer8512223strainer
straiter8311783straiter
strander97112063strander
stranger94715103stranger
strapper1258093strapper
strappier1345143strappier
strayer104312503stra_yer
streaker12229483strea_ker
streambed1483333streambed
streamed11258903stream_ed
streamers11228073stream_ers
streamiest1245123streamiest
streaming12239653streaming
streamlet1146043streamlet
streamliner1352173streamliner
stripier1058863stripier
strummer1234783strummer
stubbier1235353stubbier
studier82510053st_udier
studlier935473studlier
stuffier14336623stuffier
stumper113610093st_umper
stumpier1255883stumpier
sturdier9216963sturdier
stymie1137623st_ymie_
stymied1335663st_ymied
stymies1239213st_ymies
sugarier937393sugarier
swamies123712063s_wamies
swamper14349313s_wamper
swampier1544593s_wampier
swearer10349953swea_rer
sweater103712723swea_ter
sweepier1355493sweepier
swimmier15174313swimmier
tamer75230103_t_am_er
tamper104618513_t_amper
teacher123714833_teacher
teamaker1445113_teamaker
teamed95418593_team_ed
teaming103917593_teaming
teamster1036293_teamster
tearer64822903_tea_rer
teaser65421523_tea_ser
techier1269243_techier
teemer85515743_teem_er
teenier72611143_teenier
temper103914093_te_mper
tentier73815923_tentier
termer85717253_term_er
terrier73414963_terrier
testier74015643_testier
thymier1534393_thymier
tramper113812163_tramper
trampier12318243_trampier
tweakier1533143tweakier
uneasier836963uneasier
unsteadier1152843unsteadier
vealier102712173_vealier
wearier103613283_wearier

Search took 10 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.423422437.4
2DLD Change Limit1461622638.62316950.2
3Display Results2632630.0962739.6
 (SQL Overall)1786912639.14219546.2
 
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.