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

98 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
levitates124786(None) 
levigates1346491levigates
levirates1247491levirates
levitate1137931levitate_
levitated1346411levitated
cavitates14168962cavitates
deviates12312732devi_ates
hesitates1269792hesitates
levigate1246622levigate_
levigated1445642levigated
levirate1147622levirate_
levitator1245492levitator
levitators1345402levitators
levities11310712levit_ies
meditates1239812meditates
veritates12310972veritates
agitates9310883_agitates
alleviates1344943allevi_ates
aviates10313063_avi_ates
bloviates1484543blovi_ates
cavitate13159833cavitate_
cavitated15177353cavitated
celibates1358633celibates
cogitates1247863cogitates
crepitates1485903crepitates
decimates14410693decimates
dedicates13311693dedicates
delicates12314313delicates
denitrates1169513denitrates
depilates12310923depilates
derivates13310093derivates
devastates1444663devastates
deviate11312713devi_ate_
deviated13311043devi_ated
elevates111110423elev__ates
eluviates1246103eluvi_ates
emirates101214853_emirates
epilates10313503_epilates
epitases1038933_epitases
estates74520183_e_states
evites94916473_evi__tes
geminates12310033geminates
gestates93213733ge_states
gravitates1444843gravitates
hebetates1446433hebetates
heritages1346713heritages
hesitate1169973hesitate_
hesitated1377783hesitated
hesitater1276923hesitater
hesitaters1374853hesitaters
imitates10310503_imitates
irritates977223irritates
labiates101011513labi_ates
lactates10311223l_actates
laminates112712903laminates
lapidates1247143lapidates
leachates1446663leachates
legates82917683le__gates
legislates1164413legislates
legitimates1454023legitimates
lenites7818443leni__tes
lenities8315943lenit_ies
lenitives1247503lenitives
lepidotes1244303lepidotes
levatores12225733levatores
leverages1365663leverages
levies93919863levi___es
leviratic1443723leviratic
levitating1446653levitating
levitation1349443levitation
levitations1448293levitations
lewisites1244213lewisites
ligates82318383l__igates
litigates1048003litigates
litotes7311183l__itotes
loricates11310123loricates
mediates112814063medi_ates
medicates14312113medicates
meditate11310623meditate_
meditated1348083meditated
metates92720013me__tates
militates11310883militates
navigates1345873navigates
novitiates1343733novitiates
obviates1345153obvi_ates
pectates122213953pe_ctates
redictates1348233redictates
resinates9314763resinates
resituates1047753resituates
restates83423433re_states
revibrates1546273revibrates
reviolates1347533reviolates
sanitates9611733sanitates
seriates82620673seri_ates
testates83615453te_states
vegetates1346403vegetates
vesicates14119033vesicates
vitiates112311433__vitiates

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.423422437.4
2DLD Change Limit148641987.26620457.1
3Display Results98980.0462130.4
 (SQL Overall)178691987.73523101.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.