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 “pelorias” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
pelorias1041059(None) 
peloria9310951peloria_
pelorian1048881pelorian
celosias1048902celosias
glorias81610322_glorias
melodias1148702melodias
peloric11310712pelori_c
pelorus939272pelor_us
pelotas9410722pelo_tas
peltries10313022peltries
apologias1247503apologias
aporias9315153_aporias
begonias1146263begonias
belfries1336983belfries
calorics122810463calorics
calories102919543calories
celeriac1246163celeriac
celeriacs1344113celeriacs
celeries10316313celeries
celosia939463celosia_
cerias83321983ce__rias
chlorids14299673chlorids
chlorins132612883chlorins
deliria868303deliria_
elodeas836963_elodeas
eloins65419383_elo_ins
eulogias946553eulogias
fedoras1137923fedor_as
felonies11310993felonies
felonries1246203felonries
ferias95020393fe__rias
floras94715693_flor_as
florins10311643_florins
gloria71910543_gloria_
glories81915913_glories
helotries1269563helotries
keloids1288663kelo_ids
kerrias11289513ke_rrias
leporids1145673leporids
lories64933043__lories
loris55329153__lori_s
malarias10313773malarias
melodia1038883melodia_
melodicas1444853melodicas
melodies11310123melodies
meloids10911453melo_ids
memorial1249523memorial
memorials1346553memorials
memories121214353memories
meropias1249963meropias
norias65518203__norias
pakoras1337473pakor_as
palookas1443843palookas
pecorini1246553pecorini
pecorino1246633pecorino
pecorinos1344033pecorinos
pedlaries12108783pedlaries
pedleries1298783pedleries
peeries93623023pe_eries
pelagial1146543pelagial
pelagics1345553pelagics
pelerine10313013pelerine
pelerines11311843pelerines
peloruses1145873peloruses
pelota8612833pelo_ta_
pelotons1038913pelotons
pelvics14245643pel_vics
pelvis113610323pel_vi_s
penuries10311663penuries
peonies93620153pe_onies
peponidas1444003peponidas
perils84121853pe__rils
peris75537073pe__ri_s
peroral9314793peror_al
peroxids1837443peroxids
perries93226603pe_rries
petunias1066013petunias
phelonia1347043phelonia_
phobias14228183p_hobias
pilgrims1344143pilgrims
pillories1189573pillories
pleuras937413pleur_as
pogonias1148513pogonias
polyurias1445493polyurias
pooris83916843p_oori_s
pretorial11512653pretorial
pretorian11511553pretorian
pretorians1258313pretorians
priories10312453priories
pylori1147163pylori__
pyloric1438063pylori_c
pylorus1235333pylor_us
pyurias1236713p_yurias
remoras9314073remor_as
senopias1048823senopias
senoras72714953senor_as
senoritas946513senoritas
thorias102312053_thorias
valonias1147473valonias
velaria1038923velaria_

Search took 10 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.233766914.2
2DLD Change Limit1461621008.92316380.4
3Display Results1001000.0631587.3
 (SQL Overall)1786911009.21919382.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.