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

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

37 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
revellers1231951(None) 
bevellers14276141bevellers
levellers12286051levellers
ravellers12257171ravellers
repellers11278881repellers
resellers9299931resellers
revealers12318241revealers
revelers113414131reve_lers
reveller112912191reveller_
bevelers13389462beve_lers
beveller13387692beveller_
drivellers1452952drivellers
grovellers1443322grovellers
jewellers1943542jewellers
levelers11259322leve_lers
leveller11317602leveller_
ravelers113310862rave_lers
raveller11339272raveller_
recallers1137102recallers
reelers73520272re_e_lers
repealers11278842repealers
repeller103010402repeller_
rerollers9207122rerollers
reseller83412252reseller_
revealer113110072revealer_
reveilles1245202reveille_s
reveler104116342reve_ler_
revelled123712742revelle_d
revengers1336412revengers
revenuers1235982revenuers
reverers113113152reve_rers
reversers12298482reversers
reverters122710432reverters
revilers114011702rev_ilers
revolters12297482revolters
revolvers15286112revolvers
travellers1364662travellers

Search took 4 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 Filter1786911214360.406440125.6
2DLD Change Limit121436373.33036467.3
3Display Results37370.0132846.2
 (SQL Overall)178691373.74947663.6
 
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.