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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 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
numerate10161039(None) 
enumerate11127351enumerate
numerated12177871numerated
numerates11199571numerates
enumerated13125782enumerated
enumerates12126742enumerates
fumarate1345682fumarate
innumerate1254412innumerate
numerable1347622numerable
numeracy1544082numeracy
numeral939082numera_l
numerals1047332numerals
numerary1344282numerary
numerator1145582numerator
underate9918602underate
acerate92818913_acerate
acierate10311813acierate
adumbrate1453363adumbrate
aerate64830553__aerate
ameerate1039633ameerate
amirate91115953_amirate
asperate10312373asperate
aurate64426473au__rate
aureate72515283aure_ate
berate84729023__berate
butyrate1346203butyrate
camerae11312063camera_e
cerate84829463__cerate
cultrate10310873cultrate
cumulate123110223cumulate
cuneate9311723cune_ate
curate85226243cu__rate
deaerate9314173deaerate
derate74531233__derate
deuterate1049513deuterate
emeerate10410103emeerate
emirate91015833_emirate
enumerable1444973enumerable
enumerative1654753enumerative
enumerator1254313enumerator
exuberate1845623exuberate
federate12310883federate
fumarase1343563fumarase
fumarates1445393fumarates
fumette1245523fume_tte
fumigate1446153fumigate
generate9312903generate
glomerate1245673glomerate
humate113214443hum__ate
humeral1238563humera_l
humerals1347173humerals
innumerates1353973innumerates
iterate71119113_iterate
lacerate102214703lacerate
liberate101113383liberate
literate81216893literate
lustrate8310443lustrate
macerate122314073macerate
metate82720533__metate
moderate11710993moderate
nameplate1344613nameplate
namesake1443243namesake
narrate7313493n_arrate
nauseate845893nause_ate
negate72915573n__egate
nervate1039533n__ervate
nitrate72017013n_itrate
nominate10312473nominate
nucleate1048673nucleate
numbat10312083num_bat_
numbats1137673num_bats
numberable1643993numberable
numerably1645973numerably
numeracies1444903numeracies
numerally1446133numerally
numerating1357233numerating
numeration12137963numeration
numerators1245553numerators
numeric1158193numer_ic
numerics1266283numerics
numerous1047843numerous
nutate63017373nu__tate
nutmeat947953nutme_at_
nutmeats1044463nutme_ats
operate9615733_operate
outrate72323183ou_trate
overate10620963_overate
quadrate1888043quadrate
ruminate10511473ruminate
summate113611663sum_mate
supernate11313273supernate
temperate1348513temperate
tolerate8312323tolerate
ulcerate1039733ulcerate
umbrae1038683_umbra_e
umbrage1236723_umbrage
uncrate9415953_uncrate
uncreate10311353uncreate
underage101012273underage
underrate10411893underrate
unmerited1239643unmerited
uprate83916543_u_prate
urate55432163_u__rate
valerate11311473valerate
venerate11312903venerate

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.423422437.4
2DLD Change Limit1461621057.25020160.3
3Display Results1051050.0303500.0
 (SQL Overall)1786911057.70323197.6
 
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.