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

88 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
levitations144829(None) 
levigations1546211levigations
levitation1349441levitation_
cavitations1647842cavitations
deviations14311162devi_ations
hesitations1448542hesitations
invitations1449052invitations
levigation1447022levigation_
levitating1446652levitati_ng
levitational1553632levitational
levitators1345402levitat_ors
limitations1348182limitations
meditations1449332meditations
recitations13314202recitations
agitations11310063_agitations
alleviations1554493allevi_ations
aviations12311553_avi_ations
bloviations1643753blovi_ations
capitations1549853capitations
cavitation1549133cavitation_
citations11312503__citations
cogitations1448903cogitations
crepitations1647473crepitations
decimations16410163decimations
dedications15310873dedications
denotations1239853denotations
dentations11413633de_ntations
depilations14310903depilations
deputations1448343deputations
derivations15611493derivations
devastations1645823devastations
deviation13312393devi_ation_
divinations15128413divinations
dubitations1456673dubitations
elevations1338633elev__ations
elicitations1446803elicitations
eluviations14115793eluvi_ations
epilations12311713_epilations
equitations2047443equitations
evictions14228623_evi_ctions
evocations15259873_evocations
excitations2049003excitations
fetations12511383fe__tations
geminations14139253geminations
gestations1139773ge_stations
gleizations21135283gle_izations
gravitations1644763gravitations
habitations1646883habitations
hebetations1656463hebetations
hesitation1349633hesitation_
imitations1259963_imitations
incitations13310883incitations
invitation13410023invitation_
irritations1147833irritations
lactations1239423l_actations
laminations1339803laminations
lavations1238973lav__ations
legations102711923le__gations
legislations1343753legislations
legitimations1654793legitimations
lenitions939473leni__tions
leviathans1651373levi_athans
levigating1545693levigati_ng
levitates1247863levitat__es
levitator1245493levitat_o_r
libations112510443l__ibations
ligations102111993l__igations
limitation1249153limitation_
litigations1247333litigations
mediations13310983medi_ations
medications1649933medications
meditation13410743meditation_
mentations12312583me_ntations
navigations1545203navigations
obviations1545463obvi_ations
peltations12311553pe_ltations
recitation12315943recitation_
refutations1448673refutations
reputations13410733reputations
restations10315843re_stations
revelations14410303revelations
revocations16410313revocations
sanitations11410843sanitations
seriations10316683seri_ations
temptations1545413temptations
vegetations1547323vegetations
visitations1447673visitations
vitiations1338743__vitiations

Search took 5 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 Filter1786911216330.390458182.1
2DLD Change Limit121633884.51626933.8
3Display Results88880.0461913.0
 (SQL Overall)178691884.95236084.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.