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

97 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
levirates124750(None) 
levigates1346501levigates
levirate1147621levirate_
levitates1247871levitates
deviates12312752devi_ates
emirates101214852_emirates
leverages1365662leverages
levigate1246622levigate_
levigated1445642levigated
leviratic1443722leviratic
levitate1137932levitate_
levitated1346412levitated
revibrates1546282revibrates
aerates74627503ae__rates
alleviates1344973allevi_ates
amirates101114803_amirates
aspirates1139613aspirates
aviates10313083_avi_ates
berates94126883be__rates
beverages1595223beverages
bloviates1484563blovi_ates
cavitates14168963cavitates
celibates1358633celibates
cerates95428253ce__rates
deaerates10313643deaerates
decimates14410693decimates
decorates12314743decorates
dedicates13311693dedicates
delicates12314313delicates
denigrates1298113denigrates
denitrates1169513denitrates
depilates12310923depilates
depurates1239823depurates
derates84028893de__rates
derivates13310103derivates
deviate11312723devi_ate_
deviated13311053devi_ated
elevates111110433elev__ates
eluviates1246113eluvi_ates
emigrates1248583_emigrates
emirate91015833_emirate_
epilates10313503_epilates
evites94916483_evi__tes
federates13310153federates
ferrates113013423fe_rrates
geminates12310043geminates
generates10312723generates
hesitates1269793hesitates
labiates101011523labi_ates
lacerates112413783lacerates
laminates112712903laminates
lapidates1247143lapidates
leachates1446663leachates
legates82917683le__gates
legislates1164413legislates
lenites7818443leni__tes
lepidotes1244303lepidotes
leverage1285393leverage_
leveraged1463783leveraged
leverets11297603leveret_s
levies93919863levi___es
levitator1245503levitator
levitators1345413levitators
levities11310713levi_ties
lewisites1244213lewisites
liberates111012953liberates
librates103412963l_ibrates
ligates82318383l__igates
literates91415653literates
litigates1048003litigates
loricates11310133loricates
lustrates939463lustrates
mediates112814073medi_ates
medicates14312113medicates
meditates1239813meditates
meliorates1288913meliorates
navigates1345873navigates
obviates1345173obvi_ates
overrates12414623overrates
perorates11417023perorates
pirates93020333__pirates
recrates102420383re_crates
regrates92618413re_grates
remigrates1348583remigrates
resinates9314773resinates
revibrate1446383revibrate_
revibrated1645443revibrated
reviolates1347543reviolates
separates11310743separates
seriates82620683seri_ates
serrates82617023se_rrates
venerates12312263venerates
veritates12310973veritates
vesicates14119033vesicates
vibrates132210623__vibrates
virgates1237923__virgates
vizirates2144663vizirates

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.423422437.4
2DLD Change Limit148641976.28023668.9
3Display Results97970.0462108.7
 (SQL Overall)178691976.74926476.7
 
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.