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

55 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
tempuras1229506(None) 
temperas12278231temperas
tempura11295261tempura_
lempiras1243852lempiras
tamburas12316052tamburas
tempera11329042tempera_
tempers113513012temper_s
templars1255262templars
temporal1246332temporal
temporals1345292temporals
tephras1236282te_phras
atemporal1343143atemporal
cesuras958693ce_suras
demurs939773dem_ur_s
empires1139853_empires
femurs1136713fem_ur_s
lempira1144193lempira_
lemures938793lem_ures
lemurs837253lem_ur_s
muras75329583__m_uras
purpuras12105073purpuras
remoras9314073rem_oras
remudas1035833rem_udas
tambouras1343493tambouras
tambura11326463tambura_
tamburs11288613tambur_s
tampalas1245473tampalas
tampers113516743tamper_s
teguas768013te_gu_as
tempehs14325153temp_ehs
temper103914093temper__
temperate1348513temperate
tempered13248223tempered
temperer12227723temperer
temperers13247023temperers
tempests1234443tempests
templar1145643temp_lar
temples112610893temp_les
templets12226143templets
temporary1653203temporary
temporise1347403temporise
tempos103812293temp__os
temps95417133temp___s
tempters12257293tempters
temptress1343133temptress
tempts10439453temp__ts
tenours72610073tenour_s
tenures7412013te_nures
tepas76521683te_p__as
tephra1136483te_phra_
terras63516973te__rras
tetras63017623te__tras
textural1544943textural
textures1597523textures
tumours976753tumour_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.470380193.6
2DLD Change Limit146162556.65621959.4
3Display Results55550.0301833.3
 (SQL Overall)178691557.15624970.8
 
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.