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

89 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
puparia114735(None) 
puparial1246311puparial
fusaria1046222fusaria
puparium1445382puparium
sudaria847972sudaria
adularia945043adularia
angaria8311553angaria
aporia8315863_aporia
aquaria1638033aquaria
aria46245423___aria
cumarin1139263cumarin
cupric1249113cup_ric
curara83712203curar_a
curari84414403curari_
curaris94114773curaris
curia74523763cu__ria
emporia1148753emporia
eupatrid1144273eupatrid
euphoria13116863euphoria
filaria1039653filaria
fumaric1446303fumaric
heparin12410433heparin
imperia1148423imperia
lunarian847293lunarian
malaria9313693malaria
maria75032883__maria
nutria639903nu_tria
ourari63413543ourari_
ouraris73512933ouraris
papain10313793papa_in
papaya1337503papa_ya
paprica1337003pap_rica
paprika1544003pap_rika
papyri1334903papyri_
papyrian1544563papyrian
para65242173__par_a
pariah114320583__pariah
parian83223963__parian
paris75145943__paris
parka115120883__parka
patagia1068783patagia
peloria9310953peloria
picara10311903picar_a
planaria1047353planaria
plumeria1244903plumeria
polyparia1645793polyparia
propria1149933propria
puerperia1343393puerperia
pugaree10208033pugaree
pupa85422813pup___a
pupae96515643pupa__e
pupal97616873pupa__l
pupas95219283pupa__s
pupate104213123pupa_te
pupated12319353pupated
pupates113311433pupates
pupating1337683pupating
pupation1269503pupation
pupil94712983pup__il
purana8712933pura_na
puranic11410483puranic
purda82914693pu__rda
puri65931443pu__ri_
purin75527593pu__rin
puris75332023pu__ris
purpura1144793purpur_a
purpuric1463763purpuric
purpurin1254583purpurin
putamina1244543putamina
putrid9311163pu_trid
pyuria1136953p_yuria
qualia1559563qu_alia
riparian1047523riparian
rosaria749253rosaria
septaria1047413septaria
sharia93116723_sharia
solaria7312493solaria
sparid94016933_sparid
subarea939403subarea
subarid10310653subarid
supra73614253sup_r_a
talaria7412503talaria
urania62516123_urania
urari54619963_urari_
uraris63817273_uraris
varia85824203__varia
velaria1038923velaria
vivaria1346983vivaria
zoaria1548373_zoaria

Search took 7 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.1701051123.5
2DLD Change Limit134027896.47020715.1
3Display Results89890.0332697.0
 (SQL Overall)178691896.67326778.2
 
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.