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

44 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
palmyras154403(None) 
palmyra1444141palmyra_
palabras1267352palabras
palmers113513622palmer_s
aliyas93911803_aliy_as
almas76629773_alm__as
ballyrag1443433ballyrag
ballyrags1543073ballyrags
balmoral1244633balmoral
balmorals1343253balmorals
calderas1147883calderas
cameras11313363ca_meras
halmas117017893halm__as
kalmias1347973kalm_ias
pakoras1337473pa_koras
palabra1137183palabra_
palapas11311493pal_apas
palestras1145723palestras
palikars1445083palikars
pallors9314363pallor_s
palmar104113463palm__ar
palmary14338553palmar_y
palmer105816543palmer__
palmfuls1543473palmfuls
palmists12268813palmists
palms94921753palm___s
palmtops1443543palmtops
palmy126016733palmy___
palookas1443843palookas
palpebras1542643palpebras
palters94021683palter_s
pampas124913993pa_m_pas
pandoras11310053pandoras
panduras1136953panduras
papayas1437273papay_as
papyral1445773pa_pyral
papyrus1444063pa_pyrus
paras76143043pa___ras
pareiras1038183pareiras
paruras9310533pa_ruras
playas114612283p_lay_as
pleuras937413p_leuras
samaras9312913sa_maras
valkyrs1732163valkyr_s

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 Filter1786911461620.423422437.4
2DLD Change Limit146162447.12620511.1
3Display Results44440.0133384.6
 (SQL Overall)178691447.56223630.1
 
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.