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

189 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
spinsters113661(None) 
spinster1036681spinster_
minsters103813922_minsters
pensters103012122_pensters
piasters102912812_piasters
pinasters1136822_pinasters
punsters103310582_punsters
sinters74024082s_in_ters
sisters73721592s_i_sters
sphincters1742072sphincters
spindlers12286452spindlers
spinners103810862spin_ners
spinsterish1652152spinsterish
spinsterly1552002spinsterly
spitters104113382spi_tters
splinters11277922splin_ters
sprinters11329362sprin_ters
stinters83312752stin_ters
assisters936353assi_sters
banisters11189473banisters
bisters93922613_bi_sters
blisters104015083bli_sters
canisters112310193canisters
cointers103616413coin_ters
diasters92913183_diasters
diesters92513603_diesters
epistlers1154113epi_stlers
fainters11349693fain_ters
fibsters13126413_fibsters
ganisters10248313ganisters
glisters93912603gli_sters
gristers94013403gri_sters
heisters113413133hei_sters
hinters103719583_hin_ters
hipsters13268793_hipsters
hoisters113513483hoi_sters
instars7411133__instars
insteps936573__insteps
inters64328053__in_ters
jointers15289323join_ters
keisters123212043kei_sters
kiesters123310153_kiesters
klisters123910483kli_sters
leisters83312823lei_sters
linters73822633_lin_ters
listers74026533_li_sters
meisters103313843mei_sters
ministers1139623_ministers
minster93914323_minster_
minters93822473_min_ters
misters93927513_mi_sters
monsters103314553_monsters
muensters1143253muensters
munsters104010553_munsters
painters103013023pain_ters
pasters94531733_p_asters
penster92811953_penster_
pesters93827093_p_esters
piaster93012883_piaster_
piastres10249303_piastres
pilasters1138223_pilasters
pilsners1035533_pilsners
pinaster1037113_pinaster_
pincers113916503_pin_cers
pinchers153510613_pinchers
pinders103720473_pin_ders
pingers104020743_pin_gers
pinites9319533_pinite_s
pinkers134118603_pin_kers
pinners93518603_pin_ners
pinschers1644383_pinschers
pinsetters1244103_pinsetters
pishers123815753_pi_shers
pissers95014753_pi_ssers
pistes85325633_pi_ste_s
plasters103518133_plasters
pointers103013723poin_ters
posters93928013_p_osters
presters103419003_presters
printers103214903prin_ters
punster92911103_punster_
punters93617043_pun_ters
quipsters2043593quipsters
reinters82614773rein_ters
rinsers73815743_rins_ers
roisters83615553roi_sters
saunters82911753saun_ters
scamsters1334993scamsters
scimiters1345123scimiters
seamsters1136333seamsters
seiners74219273sein__ers
seisers73816393sei_s_ers
semesters1139123semesters
shifters14319863shi_fters
shiners104015943shin__ers
shinglers13246443shinglers
shunters113210753shun_ters
shysters14106463s_hysters
sifters103714793s_i_fters
sighters122510603s_ighters
singers83824703s_in_gers
sinister838583s_inister_
sinkers113618543s_in_kers
sinners74019023s_in_ners
sinter63625923s_in_ter_
sister64421583s_i_ster_
sitters74221553s_i_tters
skinkers11298183skin_kers
skinners12347293skin_ners
skirters12337243ski_rters
skitters12349553ski_tters
slicksters1643383slicksters
slighters1346713slighters
slingers93712683slin_gers
slitters84014133sli_tters
smiters93414363smi__ters
snifters11318613sni_fters
songsters1046113songsters
spankers14369863span_kers
spanners103710773span_ners
spatters103914703sp_atters
specters122811063sp_ecters
speedsters1342813speedsters
spelters103912243sp_elters
spencers12269193spen_cers
spenders113211743spen_ders
spenses92913573spens_e_s
sphincter1642233sphincter_
spicers113815553spi__cers
spiders103914413spi__ders
spielers10319653spi_elers
spiers84421743spi___ers
spikers135311993spi__kers
spillers103311703spi_llers
spinages11289293spinage_s
spinate93114813spinate__
spindler11297983spindler_
spindles112710353spindle_s
spineless1136133spineless
spinels94512443spin__els
spines85132033spin__e_s
spinets94714813spin__ets
spinier93715163spin_ier_
spininess1137963spininess
spinless10238703spin_less
spinnakers1641913spinnakers
spinner93912263spin_ner_
spinnery13416593spin_nery
spinneys13335553spin_neys
spinnies103210543spinnie_s
spinors939423spin__ors
spintos939133spin_t_os
spinules10249333spinule_s
spites84127333spi__te_s
spitter94015183spi_tter_
splashers1445283splashers
splatters11327543splatters
splinter10329703splin_ter_
splintery14264793splin_tery
splitters11307323splitters
splutters11286273splutters
spongers1137603spon_gers
sponsors1045753spons_ors
sporters103714063sp_orters
spotters104313383sp_otters
spouters104011163sp_outers
springers12309983sprin_gers
sprinklers1642973sprinklers
sprinter103810813sprin_ter_
spurters103311703sp_urters
sputters104012873sp_utters
spymasters1742803spymasters
squinters1835523squin_ters
stingers94012743stin_gers
stinkers123111133stin_kers
stinter73614513stin_ter_
suiters73618883sui__ters
supinates1139553supinate_s
supinators1245643supinators
swifters14277483swi_fters
swindlers13306033swindlers
swingers123710423swin_gers
swishers14328053swi_shers
thirsters1235233thirsters
tinters74221113_tin_ters
tipsters10278513_tipsters
twisters11268173twi_sters
waisters113811523wai_sters
winters103720483_win_ters

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411897.32620289.5
3Display Results1891890.0802362.5
 (SQL Overall)1786911897.84222786.4
 
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.