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

92 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
levigates134649(None) 
levigate1246621levigate_
levigated1445641levigated
levirates1247491levirates
levitates1247861levitates
deviates12312732devi_ates
legates82917682le__gates
levirate1147622levirate_
levitate1137932levitate_
levitated1346412levitated
ligates82318382l__igates
litigates1048002litigates
navigates1345872navigates
alleviates1344943allevi_ates
aviates10313063_avi_ates
bloviates1484543blovi_ates
cavitates14168963cavitates
celibates1358633celibates
decimates14410693decimates
dedicates13311693dedicates
delegates1139843delegates
delicates12314313delicates
denigrates1298113denigrates
depilates12310923depilates
derivates13310093derivates
derogates11310973derogates
designates1246363designates
deviate11312713devi_ate_
deviated13311043devi_ated
divagates1444733divagates
elevates111110423elev__ates
elongates1045383elongates
eluviates1246103eluvi_ates
emigrates1248583_emigrates
emirates101214853_emirates
epilates10313503_epilates
ergates8314493_e_rgates
evites94916473_evi__tes
frigates12310933_frigates
fumigates1545573fumigates
geminates12310033geminates
headgates1446383headgates
hesitates1269793hesitates
irrigates1057253irrigates
labiates101011513labi_ates
laminates112712903laminates
lapidates1247143lapidates
leachates1446653leachates
legate72917453le__gate_
legated92513983le__gated
legatee82814633le__gatee
legatees9258433le__gatees
legatos82711183le__gatos
legislates1164413legislates
lenites7818443leni__tes
lepidotes1244303lepidotes
leverages1365663leverages
levies93919863levi___es
levigating1545693levigating
levigation1447023levigation
levigations1546213levigations
leviratic1443723leviratic
levitator1245493levitator
levitators1345403levitators
levities11310713levi_ties
lewisites1244213lewisites
liftgates1343513liftgates
ligases82310713l__igases
ligate72519253l__igate_
ligated92414143l__igated
litigate948303litigate_
litigated1146563litigated
loricates11310123loricates
mediates112814063medi_ates
medicates14312113medicates
meditates1239813meditates
mitigates1248253mitigates
navigate1246073navigate_
navigated1445483navigated
negates83215843ne__gates
obligates12207853obligates
obviates1345153obvi_ates
ravigotes1343513ravigotes
relegates10310943relegates
remigrates1348573remigrates
resinates9314763resinates
revibrates1546263revibrates
reviolates1347533reviolates
seriates82620673seri_ates
veritates12310973veritates
vesicates14119033vesicates
virgates1237923__virgates

Search took 10 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.1701051123.5
2DLD Change Limit148641929.18616181.3
3Display Results92920.0462000.0
 (SQL Overall)178691929.40219005.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.