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

119 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
peloria931095(None) 
pelorian1048881pelorian
pelorias10410591pelorias
peloric11310711peloric
celosia939462celosia
deliria868302deliria
gloria71910542_gloria
melodia1038882melodia
pelorus939272pelorus
pelota8612832pelo_ta
phelonia1347042phelonia
pylori1147162pylori_
pyloric1438062pyloric
velaria1038922velaria
aerobia939463aerobia
allodia8128793allodia
alodia71112453_alodia
apologia1147723apologia
aporia8315863_aporia
begonia1047213begonia
begorra1043543begorra
caloric113413223caloric
calorie92716893calorie
celeriac1246163celeriac
celosias1048903celosias
ceria75125353ce__ria
chloric143410613chloric
chlorid133211843chlorid
chlorin123113003chlorin
ciboria1147043ciboria
coria75828323__coria
elodea738673_elodea
eloin55923203_elo_in
eluvia936133_eluvia
emporia1148753emporia
ephori1139603ephori_
eulogia846663eulogia
exordia1544983_exordia
fedora1038593fedor_a
femora1149583femor_a
feria85922713fe__ria
filaria1039653filaria
flora85317103_flor_a
florid10311453_florid
florin9312653_florin
glorias81610323_glorias
keloid11812623kelo_id
kerria10339913ke_rria
leporid1048153leporid
logia68116603__logia
lorica8310443__lorica
loris55329153__loris
malaria9313693malaria
melodias1148703melodias
melodic1238543melodic
melodica1344983melodica
meloid9616003melo_id
memorial1249523memorial
meropia1149613meropia
noria55722183__noria
pakora1247283pakor_a
pallia83015593pal_lia
palooka1344503palooka
pecorini1246553pecorini
pecorino1246633pecorino
peculia1147133peculia
peerie83617893pe_erie
pelagial1146543pelagial
pelagic1237863pelagic
pelerine10313013pelerine
pelitic111814653pelitic
pelon74423213pelo__n
pelotas9410723pelotas
peloton938743peloton
peltries10313023peltries
peltry11288653peltr_y
pelvic13307553pel_vic
pelvis113610323pel_vis
pennia84412973pe_nnia
peponida1345183peponida
perea75026443pe__rea
pereia85217983pe_reia
peri65636973pe__ri_
peridia10312363peridia
peril75425953pe__ril
peris75537073pe__ris
peroral9314793peroral
peroxid17310263peroxid
petunia966803petunia
phobia13278603p_hobia
pilgrim1244643pilgrim
pleonic1139433pleonic
pleura837533pleur_a
podia8415283p__odia
pogonia1048933pogonia
polyuria1355823polyuria
poori74816233p_oori_
pooris83916843p_ooris
pretorial11512653pretorial
pretorian11511553pretorian
propria1149933propria
puparia1147353puparia
pylorus1235333pylorus
pyuria1136953p_yuria
remora8414583remor_a
remorid10311863remorid
scoria8513503_scoria
senopia949233senopia
senora63216153senor_a
senorita848283senorita
sensoria8117533sensoria
solaria7312493solaria
talaria7412513talaria
telia55821143tel__ia
teloi54217383telo_i_
telomic1147603telomic
tentoria8119263tentoria
thoria93012893_thoria
valonia1048303valonia

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.1431249587.4
2DLD Change Limit1340271196.87319500.5
3Display Results1191190.0462587.0
 (SQL Overall)1786911197.06225303.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.