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

48 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
tempested144403(None) 
tempered13248212tempe_red
tempest1139222tempest__
tempests1234442tempest_s
tempted12317282temp__ted
bemisted1368383bem_isted
cemented1338373cem_ented
competed154113593compe_ted
composted16378813composted
demasted1238763dem_asted
demented12311273dem_ented
dempster1355773demp_ster
detested10279623de_tested
devested13239133de_vested
egested938123_e_gested
expected2036743_expected
experted1838053_experted
hempseed1643603hemp_seed
impasted13297553_impasted
imposted13257403_imposted
reested82916233re__ested
remelted11310153rem_elted
renested92212953re_nested
repasted112611533re_pasted
repeated113117443re_peated
repented112614983re_pented
requested1935893requested
respected1438493respected
retested92212533re_tested
revested122612243re_vested
semester1038903sem_ester
tampered13279463tampe_red
telneted935073telne_ted
telnetted1043813telnetted
temped113912893temp___ed
temperate1348513temperate_
temperer12227723tempe_rer
tempesting1544443tempesting
template1238433template_
templates1348263templates
templed12278553temp__led
tempter11358213temp__ter
tepefied1444573te_pefied
tested74421523t___ested
trapesed1136473trapes_ed
trapnested1343283trapnested
trumpeted1443053trumpe_ted
tumesced1343523tum_esced

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 Filter1786911486410.1731032896.0
2DLD Change Limit148641486.51322822.2
3Display Results48480.0331454.5
 (SQL Overall)178691486.71926594.9
 
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.