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

236 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
spinster103668(None) 
spinsters1136611spinsters
minster93914322_minster
penster92811952_penster
piaster93012882_piaster
pinaster1037112_pinaster
punster92911102_punster
sinister838582s_inister
sinter63625922s_in_ter
sister64421582s_i_ster
sphincter1642232sphincter
spinate93114812spinate_
spindler11297982spindler
spinier93715162spin_ier
spinner93912262spin_ner
spinsterly1552002spinsterly
spitter94015182spi_tter
splinter10329702splin_ter
sprinter103810812sprin_ter
stinter73614512stin_ter
assister836753assi_ster
banister10199973banister
bister84922763_bi_ster
blister94415313bli_ster
canister101710853canister
cointer93616723coin_ter
diaster82813313_diaster
diester83013683_diester
epistler1044833epi_stler
fainter103611053fain_ter
fibster12146533_fibster
ganister9178993ganister
glister84013343gli_ster
grister83915413gri_ster
heister103613623hei_ster
hinter94021303_hin_ter
hipster12288783_hipster
hoister103714203hoi_ster
instar6310013__instar
instep838193__instep
inter55028493__in_ter
jointer14379713join_ter
keister113011573kei_ster
kiester11329973_kiester
klister113410643kli_ster
leister73212753lei_ster
linter64625343_lin_ter
lister64527253_li_ster
meister93114163mei_ster
minister10410363_minister
minsters103813923_minsters
minter84425103_min_ter
minuter93510413_minuter
mister84728563_mi_ster
moister94015373moi_ster
monster93214603_monster
muenster1043313muenster
munster93710523_munster
painter93814563pain_ter
paster85734373_p_aster
pensters103012123_pensters
pester84827593_p_ester
piasters102912813_piasters
piastre9307893_piastre
pilaster1038163_pilaster
pilsner935343_pilsner
pinasters1136823_pinasters
pincer104019173_pin_cer
pincher143812713_pincher
pinder94523453_pin_der
pinger94324093_pin_ger
pinier84024693_pin_ier
pinite8321243_pinite_
pinites9319533_pinites
pinker125322443_pin_ker
pinner84521503_pin_ner
pinscher1544803_pinscher
pinsetter1145013_pinsetter
pisher114317753_pi_sher
pisser84416383_pi_sser
piste75824603_pi_ste_
pistes85325633_pi_stes
plaster93318693_plaster
pointer93814933poin_ter
poster84129173_p_oster
prester93519623_prester
printer93917303prin_ter
punsters103310583_punsters
punter84320023_pun_ter
quipster1933933quipster
reinter73116843rein_ter
rinser64317213_rins_er
roister73516203roi_ster
sainted84114243sain_ted
saunter72913453saun_ter
scamster1235303scamster
scanter94215183scan_ter
scimiter1236143scimiter
seamster1037143seamster
seiner64622483sein__er
seiser65318343sei_s_er
semester1038903semester
shifter132911083shi_fter
shiner93820873shin__er
shingler12268633shingler
shinier104113143shin_ier
shunter103611733shun_ter
shyster13116563s_hyster
sifter94516233s_i_fter
sighter113412113s_ighter
singer74227313s_in_ger
sinker103620903s_in_ker
sinner64320603s_in_ner
sinters74024083s_in_ters
sissier73711363s_issier
sisters73721593s_i_sters
sitter63323383s_i_tter
skinker10319443skin_ker
skinner11348093skin_ner
skinnier1264893skinnier
skirter11338483ski_rter
skitter113810403ski_tter
slickster1543413slickster
slighter1257823slighter
slimsier1085213slimsier
slinger83413833slin_ger
slinkier12206933slinkier
slitter73615873sli_tter
smiter83616413smi__ter
snifter10349623sni_fter
songster935793songster
sonsier7711743s_onsier
spanker133612353span_ker
spanner94312563span_ner
sparser94311483spars_er
spatter94016523sp_atter
specter113111733sp_ecter
speedster1252733speedster
spelter94113703sp_elter
spencer113610973spen_cer
spender103713693spen_der
spendier1147143spendier
spense83912433spens_e_
spenses92913573spens_es
sphincters1742073sphincters
spicate113214193spicate_
spicated13309903spicated
spicer104719313spi__cer
spicier115112463spi_cier
spider94516803spi__der
spieler93111233spi_eler
spier75728033spi___er
spiffier16255883spiffier
spiker124315663spi__ker
spikier13369983spi_kier
spiller92914333spi_ller
spinage10289653spinage_
spinages11289293spinages
spindle103210093spindle_
spindled12287643spindled
spindlers12286453spindlers
spindles112710353spindles
spindlier1253873spindlier
spine76534423spin__e_
spined95423943spin__ed
spinel85317333spin__el
spines85132033spin__es
spinet85629753spin__et
spinets94714813spinet_s
spinifex2042053spinifex
spinnaker1542313spinnaker
spinners103810863spin_ners
spinnery13416593spin_nery
spinney12438923spin_ney
spinnies103210543spinnies
spinor839943spin__or
spinose937943spinose_
spins75327983spins___
spinsterish1652153spinsterish
spinto8410663spin_t_o
spintos939133spin_tos
spinule9299993spinule_
spinules10249333spinules
spirier93214073spi_rier
spirited1148973spirited
spirted103913073spi_rted
spite75430663spi__te_
spited94820443spi__ted
spites84127333spi__tes
spitted103912703spi_tted
spitters104113383spi_tters
splasher1335663splasher
splatter10348883splatter
splinted11369253splin_ted
splinters11277923splin_ters
splintery14264793splin_tery
splitter10348443splitter
splutter10357443splutter
sponger1038523spon_ger
spongier1135743spongier
sponsor934973spons_or
sporter93616553sp_orter
spotter94514883sp_otter
spouter94213223sp_outer
springer113311753sprin_ger
springier1236023springier
sprinkler1543573sprinkler
sprinted113411163sprin_ted
sprinters11329363sprin_ters
spunkier14235823spunkier
spurter94013003sp_urter
sputter94014053sp_utter
spymaster1642583spymaster
squinter1747363squin_ter
stinger84314683stin_ger
stingier9279123stingier
stinker113313313stin_ker
stinkier12278543stinkier
stinted82914193stin_ted
stinters83312753stin_ters
suiter64121813sui__ter
supinate10310313supinate_
supinated1237883supinated
supinates1139553supinates
supinator1145863supinator
swifter13318053swi_fter
swindler12257723swindler
swinger113812563swin_ger
swingier12267003swingier
swisher13369523swi_sher
thirster1135673thirster
tinter63923643_tin_ter
tipster9299053_tipster
twister10308953twi_ster
waister103812383wai_ster
winter94222803_win_ter

Search took 7 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 Limit1461622366.34323043.0
3Display Results2362360.0932537.6
 (SQL Overall)1786912366.85926052.0
 
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.