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

39 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
tabouleh134279(None) 
tabbouleh1651541tabbouleh
taboulehs1441971taboulehs
tabboulehs175922tabboulehs
tabooley1342992tabooley
tabouli945842taboul_i
taboulis1045042taboulis
taboured1156272taboured
tabourer1035742tabourer
tabouret1049172tabouret
aboulia966553_aboulia
aboulic1156283_aboulic
boule74828043__boule_
boules84925973__boules
ciboule1145093ciboule_
ciboules1244533ciboules
laboured1156323laboured
labourer1045753labourer
table75429603tab__le_
tabled94020043tab__led
tables84524893tab__les
tablet84227643tab__let
tabooed10267383tabo_oed
tabooleys1441733tabooleys
tabored102810563tabo_red
taborer9269293tabo_rer
taboret92916113tabo_ret
tabour84011323tabou__r
tabourers1144673tabourers
tabourets1144163tabourets
tabours94110093tabou_rs
tabued94310403tab_u_ed
tabular9279763tab_ular
tabuli839363tab_ul_i
tabulis938833tab_ulis
tamboured1443783tamboured
tambourer1343493tambourer
tubule839853tub_ule_
tubules9310233tub_ules

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.1601116818.8
2DLD Change Limit146162396.90321173.7
3Display Results39390.0162437.5
 (SQL Overall)178691397.07925242.4
 
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.