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

93 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
fabulates144773(None) 
fabulate1339201fabulate_
fabulated1546321fabulated
tabulates1139141tabulates
ablates92416902_ab_lates
adulates9311912_adulates
ambulates1348382ambulates
canulates11312872canulates
fabulator1445392fabulator
fabulators1544692fabulators
jaculates182810362jaculates
maculates132013722maculates
tabulate10310892tabulate_
tabulated1237302tabulated
tubulates1147232tubulates
abates85825033_ab__ates
ablate82219213_ab_late_
ablated102513443_ab_lated
acylates1339743_acylates
adulate8313233_adulate_
adulated1039753_adulated
alates64833963_a__lates
ambulate1239733ambulate_
ambulated1457133ambulated
angulates10310863angulates
calculates1498703calculates
cannulates1247783cannulates
canulate10314553canulate_
canulated12310673canulated
caudates11310263ca_udates
coagulates13137453coagulates
confabulates1953493confabulates
copulates132612463copulates
cumulates13258973cumulates
ejaculates19166443ejaculates
emulates10312573_emulates
fables114921673fab_l__es
fabricates1746463fabricates
fabular12288693fabula__r
fabulating1645513fabulating
fabulists1444723fabulists
fabulous1344853fabul_ous
faceplates1744613faceplates
faculae123210353facula_e_
faculties1455143faculties
faulted11227723fa_ul_ted
faults94513553fa_ul_t_s
fayalites1546063fayalites
fellates11312753f_ellates
fibulae12237013fibula_e_
fibulas12228563fibula__s
folates103218453f__olates
formulates1546543formulates
gallates92815523ga_llates
granulates1148463granulates
gratulates1157133gratulates
hamulate1359013hamulate_
haulages1236623ha_ulages
insulates9311843insulates
jaculate172311783jaculate_
jaculated19289053jaculated
jubilates1845843jubilates
jugulates1744603jugulates
labiates101011513lab_iates
lazulites1844253lazulites
lobulate1078833lobulate_
lobulated12106423lobulated
maculate122815623maculate_
maculated142411503maculated
malates93522603ma__lates
maturates11311763maturates
modulates1238053modulates
oblates91913243_ob_lates
osculates11109393osculates
ovulates1148523_ovulates
palates93624933pa__lates
peculates132112543peculates
populates132710673populates
regulates101211723regulates
saturates9811603saturates
sibilates1148443sibilates
simulates1139853simulates
sublates10315003sub_lates
subulate10312743subulate_
tabulator1145923tabulator
tabulators1245293tabulators
tribulates1247203tribulates
tubulate1038273tubulate_
tubulated1256063tubulated
ululates848433_ululates
undulates1048923undulates
ungulates1048353ungulates
valuates112811203valu_ates

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641936.87621617.4
3Display Results93930.0462021.7
 (SQL Overall)178691937.07825246.0
 
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.