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

241 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
pioneers103586(None) 
pioneer936891pioneer_
pickeers16347242pickeers
pincers113916502pi_ncers
pinders103720472pi_nders
pingers104020742pi_ngers
pinkers134118602pi_nkers
pinners93518602pi_nners
pioneered1253732pioneered
pointers103013722pointers
ponders103618842p_onders
atoners75013953aton_ers
binders103920743bi_nders
biners85023633bi_n_ers
bingers104519993bi_ngers
biometers1339173biometers
bonders104120663_bonders
boners84825433_bon_ers
bonkers134015303_bonkers
bronzers19296983bronzers
cinders104617763ci_nders
cloners94514823clon_ers
coiners93620753coin_ers
coinfers13349503coinfers
cointers103616423cointers
confers124120093_confers
congers104223233_congers
conkers133721043_conkers
conners94023113_conners
diners75525953di_n_ers
dingers94321383di_ngers
dinners83915443di_nners
diopters1137693diopters
donees74519493_donee_s
droners84114383dron_ers
finders113717873fi_nders
fingers113418433fi_ngers
gingers94118643gi_ngers
ginners84314223gi_nners
goners74420173_gon_ers
hinders113718503hi_nders
hingers113420213hi_ngers
hinters103719583hi_nters
honers94324973_hon_ers
honkers143315233_honkers
infers93615443_i_nfers
inkers104018833_i_nkers
inners63919353_i_nners
inters64328053_i_nters
ionizers17257713_ionizers
ionomers1038503_ionomers
ironers74813553iron_ers
jinkers183511813ji_nkers
joinders16337203joinders
joiners144211573join_ers
jointers15289323jointers
limners93311563limn_ers
liners65428853li_n_ers
lingers84223303li_ngers
linkers114317713li_nkers
linters73822633li_nters
lioness739103lion_ess
lionisers944173lionisers
lionizers1844243lionizers
liveners11217933liveners
loners64225813_lon_ers
longers84819543_longers
mijnheers2141613mijnheers
mincers113714853mi_ncers
minders103720123mi_nders
miners84126633mi_n_ers
minters93822473mi_nters
moneyers1337423_moneyers
mongers104217273_mongers
mooners94015343moon_ers
optionees1144343optionee_s
painters103013023painters
panders103423733p_anders
paniers94717333p_aniers
panners93621273p_anners
panniers10488853panniers
panzers184012013p_anzers
pawnees12298173pawnee_s
pawners124311073pawn_ers
peers75130273p___eers
penners93414183p_enners
peones83821043peon_e_s
peonies93620153peonie_s
peoplers1237163peoplers
phonemes1546193phonemes
phones114121213phon_e_s
phoneys15437143phon_eys
phonier122710633phonier_
phonies123717513phonie_s
piaffers16114203piaffers
piasters102912813piasters
pickeer153710113pickeer_
pickers153718093pi_ckers
picketers17196483picketers
picometers1648283picometers
picotees1247113picotee_s
piddlers12359593piddlers
piecers114112253pi_ecers
piercers12316723piercers
piers75926333pi___ers
pigweeds1553143pigweeds
pikers124717393pi__kers
pilferers1444583pilferers
pilfers1238963pi_lfers
pilseners1144943pilseners
pilsners1035533pilsners
pincer104019173pi_ncer_
pinchers153510613pinchers
pinder94523453pi_nder_
pineals93212853pi_neals
pinenes93416683pi_nenes
pinery115214293pi_n_ery
pines76048863pi_n_e_s
pinger94324093pi_nger_
pinier84024693pi_nier_
pinkens13419643pi_nkens
pinker125322443pi_nker_
pinkeys16378213pi_nkeys
pinner84521503pi_nner_
pinnies93318443pinnie_s
pinoles93418703pinole_s
pinones94717073pinone_s
pinweeds1454143pinweeds
piolets93513193pio_lets
pioneering1354393pioneering
pions75826393pion___s
pipers104318663pi__pers
pishers123815753pi_shers
pissers95014753pi_ssers
pistoleers1243793pistoleers
pitchers153211483pitchers
pitiers93812653pi_tiers
planers94517943plan_ers
planners10399933planners
planters102915323planters
plinkers14309393plinkers
plodders1235523plodders
plotters104011553plotters
plovers123611833plo_vers
plowers123812243plo_wers
plunders11329833plunders
plungers11379403plungers
plunkers14328333plunkers
pointer93814933pointer_
pointes93216753pointe_s
poisers94214433p_oisers
poisoners1146113poison_ers
pokers124617923p_o_kers
polders103617373p_olders
polers84225643p_o_lers
pollers93420023p_ollers
ponces104720843p_once_s
ponder94521693p_onder_
ponderers12248453p_onderers
pones74547043p_on_e_s
pongees104212543p_ongees
ponies84833463p_onie_s
pontes83627853p_onte_s
poofters1336923poofters
poolers94217423p_oolers
poppers103414863p_oppers
porkers134314933p_orkers
porters93722703p_orters
posers84223973p_o_sers
poseurs9378303p_oseurs
posters93928013p_osters
poteens92910883p_oteens
pothers123818623p_others
potters94024343p_otters
potzers184010543p_otzers
pouncers12349203pouncers
pounders113113283pounders
pourers93513673p_ourers
pouters94221873p_outers
powders134111553p_owders
powers113822323p_o_wers
powters124015663p_owters
prancers123210333prancers
preeners102712813preeners
prinkers143010383prinkers
printers103214903printers
prisoners1147373prison_ers
probers113514583pro_bers
proceeds1335983proceeds
prodders1237463prodders
proffers16126593proffers
proggers12258163proggers
proneness11310443proneness
proofers13118363proofers
propers113619033pro_pers
prosers94219643pro_sers
prospers123012263prospers
provers123817793pro_vers
prowlers13328933prowlers
pruners93710723prun_ers
punkers133714853p_unkers
punners94114233p_unners
punters93617043p_unters
ringers83922953ri_ngers
rinsers73815743ri_nsers
rioters73615523rio_ters
ripeners1036843ripeners
signees83510803signee_s
signers84714443sign_ers
singers83824703si_ngers
sinkers113618543si_nkers
sinners74019023si_nners
sinters74024083si_nters
sneers64016173__sneers
sonders83820713_sonders
sooners73916643soon_ers
spinners103810863spi_nners
spongers1137603spongers
stoners74817953ston_ers
tinders84219173ti_nders
tinkers113517143ti_nkers
tinners73717313ti_nners
tinters74221113ti_nters
toners64128003_ton_ers
tongers84116013_tongers
tonners73816403_tonners
veneers103710293_veneers
wideners12257993wideners
wieners103212483wien_ers
wincers123415363wi_ncers
winders113721263wi_nders
wingers113921483wi_ngers
winkers143517113wi_nkers
winners104316913wi_nners
winters103720483wi_nters
wonders113315993_wonders
wonners104312813_wonners
wrongers12327773wrongers
yonkers14379823_yonkers
zingers173514853zi_ngers
zoners155115993_zon_ers

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.423422437.4
2DLD Change Limit1461622418.07618098.3
3Display Results2412410.0962510.4
 (SQL Overall)1786912418.59520790.1
 
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.