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

220 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
piastres1024930(None) 
piasters102912811piasters
piastre9307891piastre_
bistres94017212bi_stres
diasters92913182diasters
pasters94531732p_asters
pastes85233912p_ast_es
pasties94529812p_asties
pastries101517422p_astries
pastures10311962p_astures
piaster93012882piast_er
pigsties1139782pigsties
pilasters1138222pilasters
pinasters1136822pinasters
pistes85325632pi_st_es
plasters103518132plasters
antres65021003__antres
asters65631603__asters
basters94930303_basters
bastes85330383_bast_es
beasties102514653beasties
biases84618433bias__es
biasses94911653bias_ses
bisters93922613bi_sters
bistre83815023bi_stre_
bistred103311853bi_stred
bistros92810983bi_stros
blasters104116143blasters
blasties102113633blasties
boasters103915663boasters
cadastres1244543cadastres
casters94729903_casters
castes85631863_cast_es
castles94917733_castles
coasters104317333coasters
diaspores1266543diaspores
diastase946603diastase
diastases1047073diastases
diastem10318043diast_em
diastems11226523diastems
diaster82813313diast_er
diastoles1047493diastoles
diastral946993diastral
diesters92513603diesters
diestrus946523diestrus
dioptres1146113dioptres
disasters1039153disasters
distress9311713di_stress
easters75125683_easters
epinasties1243793epinasties
epistles1047783epi_stles
erasures837213erasures
feasters11511563feasters
fiacres1237253fia_cres
fiascoes13134923fiascoes
fibsters13126413fibsters
fissures1136573fissures
gasters85624293_gasters
gastrea847233_gastrea
gastreas957253_gastreas
hastes95727073_hast_es
hipsters13268793hipsters
insures73117263_insures
istles62814983_i_stles
kiesters123310153kiesters
lasters75627693_lasters
listees73416673li_stees
listers74026533li_sters
litres65220393li__tres
lustres73013233_lustres
masters94628923_masters
matres84522233_ma_tres
measures1038913measures
minsters103813923minsters
minstrel1046913minstrel
minstrels1145693minstrels
misters93927513mi_sters
mistress10310703mi_stress
mitres83922073mi__tres
nasties73520493_nasties
nitres65519333ni__tres
opiates9312143opia_t_es
padres95016983p_a_dres
painters103013023painters
palters94021683p_alters
panties94230933p_anties
pantries101817393p_antries
pares77164483p_a__res
parties93230863p_arties
parures9512693p_arures
pases75346503p_as__es
pashes115828393p_as_hes
passers94717753p_assers
passes86030473p_as_ses
pastas85422873p_ast_as
paste74932953p_ast_e_
pasted94426903p_ast_ed
pastel85918713p_ast_el
pastels95215183p_astels
paster85734373p_ast_er
pastern94415063p_astern
pasterns104112623p_asterns
pastie85525523p_astie_
pastier94320383p_astier
pastiest103319543p_astiest
pastils94416173p_astils
pastimes123611903p_astimes
pastis84924323p_ast_is
pastises103616053p_astises
pastless102411203p_astless
pastness102510503p_astness
pastored1139963p_astored
pastors94119003p_astors
pastry114913033p_astr_y
pasts75936503p_ast__s
pasture9311463p_asture_
pastured1138233p_astured
pasturer1037523p_asturer
pasturers1136393p_asturers
paters84935833p_a_ters
pates76047893p_a_t_es
patsies93919483p_atsies
patters94825193p_atters
patties93425143p_atties
peases85229473peas__es
pensters103012123pensters
pesters93827093p_esters
pestles93217693p_estles
phases114618403phas__es
philtres1396513philtres
piaffers16114203piaffers
piaffes15115053pia_ffes
piasabas1243883piasabas
piasavas1343333piasavas
picadores1444363picadores
picotees1247113picotees
pictures1249343pictures
pieties9419223pi_eties
pilaster1038163pilast_er
pilsners1035533pilsners
pinafores1444503pinafores
pinaster1037113pinast_er
pinites9319533pinit_es
pinstripes1443973pinstripes
pintles94118723pi_ntles
pintoes95117713pi_ntoes
piosities11311723piosities
pipettes1237563pipettes
pipistrel1351843pipistrel
pipistrels1451503pipistrels
pirates93020333pirat_es
pishers123815753pi_shers
pishes114722103pi_s_hes
pismires1235883pismires
pissers95014753pisser_s
pisses84525083pi_s_ses
piste75824603pi_st_e_
pistils93314303pi_stils
pistoles102514723pi_stoles
pistols93213983pi_stols
pistons93016373pi_stons
pistous92714383pi_stous
pities83828083pi__ties
plaisters1137813plaisters
plaiters103512633plaiters
planters102915323planters
plashers133813453plashers
plashes124417393plas_hes
plaster93318693plast_er
plastered1288893plastered
plasterer1178103plasterer
plasterers1286123plasterers
plastery13279703plastery
plastics122412333plastics
plastids11269213plastids
plastral1046913plastral
plastron1046913plastron
plastrons1147133plastrons
plastrum1245713plastrum
plastrums1344513plastrums
platers93924093pla_ters
plates85432243pla_t_es
platies93722543pla_ties
platters103415283platters
pleasures1145573pleasures
posters93928013p_osters
posties93128813p_osties
postures10313783p_ostures
prases84429023pras__es
praters94921653pra_ters
prates84633163pra_t_es
prattles10189403prattles
presters103419003presters
prestores114716083prestores
prestress1138133prestress
priseres10310823priseres
prosties101421193prosties
psalters10227713psalters
psaltries1185743psaltries
punsters103310583punsters
quatres163411933qua_tres
rasters74629023_rasters
rasures7312013_rasures
ristras7311563ri_stras
roasters83615933roasters
sisters73721593si_sters
spinsters1136613spinsters
tasters74225643_tasters
tastes64126423_tast_es
tipsters10278513tipsters
titres64718933ti__tres
toasters83912723toasters
viatores11257683viatores
waisters113811523waisters
wasters104026593_wasters
wastes96224883_wast_es
wastrel1037553_wastrel
wastrels1136203_wastrels
wastries111212883_wastries
wrastles11328933wrastles

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.450397091.1
2DLD Change Limit1461622207.67319048.9
3Display Results2202200.0762894.7
 (SQL Overall)1786912208.19921794.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.