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
levirates1247481levirates
levitates1247861levitates
deviates12312732devi_ates
legates82917672le__gates
levirate1147622levirate_
levitate1137932levitate_
levitated1346412levitated
ligates82318372l__igates
litigates1048002litigates
navigates1345872navigates
alleviates1344943allevi_ates
aviates10313063_avi_ates
bloviates1484543blovi_ates
cavitates14168963cavitates
celibates1358623celibates
decimates14410693decimates
dedicates13311693dedicates
delegates1139833delegates
delicates12314313delicates
denigrates1298103denigrates
depilates12310923depilates
derivates13310083derivates
derogates11310963derogates
designates1246363designates
deviate11312713devi_ate_
deviated13311043devi_ated
divagates1444733divagates
elevates111110413elev__ates
elongates1045383elongates
eluviates1246103eluvi_ates
emigrates1248563_emigrates
emirates101214843_emirates
epilates10313503_epilates
ergates8314473_e_rgates
evites94916473_evi__tes
frigates12310923_frigates
fumigates1545573fumigates
geminates12310033geminates
headgates1446383headgates
hesitates1269793hesitates
irrigates1057253irrigates
labiates101011513labi_ates
laminates112712903laminates
lapidates1247143lapidates
leachates1446653leachates
legate72917453le__gate_
legated92513983le__gated
legatee82814633le__gatee
legatees9258423le__gatees
legatos82711183le__gatos
legislates1164413legislates
lenites7818443leni__tes
lepidotes1244303lepidotes
leverages1365653leverages
levies93919863levi___es
levigating1545693levigating
levigation1447023levigation
levigations1546213levigations
leviratic1443723leviratic
levitator1245493levitator
levitators1345403levitators
levities11310713levi_ties
lewisites1244213lewisites
liftgates1343513liftgates
ligases82310703l__igases
ligate72519243l__igate_
ligated92414133l__igated
litigate948303litigate_
litigated1146563litigated
loricates11310123loricates
mediates112814063medi_ates
medicates14312113medicates
meditates1239813meditates
mitigates1248253mitigates
navigate1246073navigate_
navigated1445483navigated
negates83215833ne__gates
obligates12207853obligates
obviates1345153obvi_ates
ravigotes1343513ravigotes
relegates10310933relegates
remigrates1348563remigrates
resinates9314763resinates
revibrates1546253revibrates
reviolates1347533reviolates
seriates82620663seri_ates
veritates12310963veritates
vesicates14119023vesicates
virgates1237903__virgates

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.1731032896.0
2DLD Change Limit148641927.11020905.9
3Display Results92920.0462000.0
 (SQL Overall)178691927.32924381.4
 
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.