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

203 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
piastre930789(None) 
piaster93012881piaster
piastres10249301piastres
bistre83815022bi_stre
diaster82813312diaster
paste74932952p_ast_e
paster85734372p_aster
pastie85525522p_astie
pastry114913032p_astry
pasture9311462p_asture
piasters102912812piasters
pilaster1038162pilaster
pinaster1037112pinaster
piste75824602pi_st_e
plaster93318692plaster
antre55224523__antre
aster55434893__aster
baste74829983_bast_e
baster85333603_baster
beastie92412433beastie
bister84922763bi_ster
bistred103311853bi_stred
bistres94017213bi_stres
bistro8339943bi_stro
blaster94017303blaster
blastie92411393blastie
boaster94616433boaster
cadastre1144283cadastre
caste75932363_cast_e
caster85232573_caster
castle84918963_castle
chaste114617393chast_e
chaster124718503chaster
coaster94219043coaster
diaspore1166063diaspore
diastase946603diastase
diastem10318043diastem
diasters92913183diasters
diastole947563diastole
diastral946993diastral
diester83013683diester
dioptre1055763dioptre
disaster949943disaster
easter65027983_easter
epistle957893epi_stle
erasure736943erasure
faster94625773_faster
feaster10812983feaster
fiacre1137623fia_cre
fibster12146533fibster
fissure1036783fissure
gaster75027353_gaster
gastrea847253_gastrea
haste85927863_hast_e
hipster12288783hipster
insure63416603_insure
istle52214713_i_stle
kiester11329973kiester
laster64830633_laster
listee64223063li_stee
lister64527253li_ster
litre55421463li__tre
lustre64011683_lustre
master84831343_master
measure939033measure
minster93914323minster
minstrel1046913minstrel
misate81222693misat_e
mister84728563mi_ster
mitre75522423mi__tre
nitre57519683ni__tre
opiate8513463opia_t_e
padre86018163p_a_dre
painter93814563painter
paise75028333pais__e
palter84423263p_alter
paltry114910403p_altry
pantie84326473p_antie
pantry115014103p_antry
pare66760843p_a__re
parure8312523p_arure
pase65346863p_as__e
passe75525693p_as_se
passee84522023p_assee
passer84721033p_asser
past65959013p_ast__
pasta76624533p_ast_a
pastas85422873p_astas
pasted94426903p_asted
pastel85918713p_astel
pastern94415063p_astern
pasters94531733p_asters
pastes85233913p_astes
pastier94320383p_astier
pasties94529813p_asties
pastil85018323p_astil
pastime114611973p_astime
pastis84924323p_astis
pastor84817483p_astor
pastored1139973p_astored
pastors94119003p_astors
pastries101517423p_astries
pasts75936503p_ast_s
pastured1138233p_astured
pasturer1037523p_asturer
pastures10311963p_astures
pasty105725053p_ast_y
pate65350463p_a_t_e
pater74740733p_a_ter
pattee84323383p_attee
patter84628263p_atter
pattie84020963p_attie
pearter9412743pearter
pease75231113peas__e
penster92811953penster
pester84827593p_ester
pestle83215843p_estle
phase104617213phas__e
phatter123810203phatter
philtre12105213philtre
piaffe1494913pia_ffe
piaffer15104443piaffer
pias66542563pias___
piasaba1144193piasaba
piasava1243883piasava
piazze1634683pia_zze
picante11310523picant_e
picotee11311473picotee
picture1158613picture
pigsties1139783pigsties
pigsty1235933pigst_y
pilasters1138223pilasters
pilsner935343pilsner
pinafore1344513pinafore
pinasters1136823pinasters
pinite8321243pinit_e
pinstripe1343783pinstripe
pintle83818263pi_ntle
pipette1137943pipette
pipistrel1351843pipistrel
pirate82322883pirat_e
pisher114317753pi_sher
pismire1135353pismire
pisser84416383pisser_
pissers95014753pissers
pistes85325633pi_stes
pistil83915073pi_stil
pistol83313333pi_stol
pistole92414313pi_stole
piston83515923pi_ston
pistou83211843pi_stou
plaister1068013plaister
plaiter93615393plaiter
planter94017813planter
plasher124215033plasher
plastered1288913plastered
plasterer1178113plasterer
plasters103518133plasters
plastery13279703plastery
plastic112815063plastic
plastid102112523plastid
plastral1046913plastral
plastron1046913plastron
plastrum1245713plastrum
plate74635113pla_t_e
plater84427693pla_ter
platter93917413platter
pleasure1045543pleasure
poster84129173p_oster
postie84123963p_ostie
posture9313253p_osture
prase76128753pras__e
prate75135983pra_t_e
prater84825353pra_ter
prattle9208833prattle
prester93519623prester
prestore104217353prestore
prisere9310943prisere
prostie91617743prostie
psalter9247813psalter
psaltry12213803psaltry
punster92911103punster
quatre153512363qua_tre
raster64731443_raster
rasure6311423_rasure
ristra6310713ri_stra
roaster74116663roaster
sister64421583si_ster
sistra639333si_stra
spinster1036683spinster
taste55127233_tast_e
taster64930573_taster
tipster9299053tipster
titre54619393ti__tre
toaster74414463toaster
vaster94521023_vaster
waister103812383waister
waste86125053_wast_e
waster95228943_waster
wastrel1037553_wastrel
wastrie101210303_wastrie
wastry12388773_wastry
wrastle10368993wrastle

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 Filter1786911340270.420425454.8
2DLD Change Limit1340272036.62620227.4
3Display Results2032030.0802537.5
 (SQL Overall)1786912037.12625075.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.