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

48 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
bloviates148454(None) 
bloviate1384911bloviate_
bloviated1573621bloviated
eluviates1246102eluviates
alleviates1344943alleviates
aviates10313063__aviates
biopirates1474163biopirates
biotites10310083bioti_tes
blites84721213bl__i_tes
bloated104513433blo__ated
bloater94013423blo__ater
bloaters103311023blo__aters
bloats85215763blo__at_s
blockades1844113blockades
blockages1844063blockages
bloviating1643813bloviating
bloviation1544003bloviation
bloviations1643753bloviations
boites84322703b_o_i_tes
bolivares1444723bolivares
boniatos1046673b_oniatos
borates94823013b_o_rates
bovines12412663b_ovi_nes
bromates12413143bro_mates
brominates1448013brominates
clodpates1444103clodpates
deviates12312733_deviates
elevates111110423elev_ates
elongates1045383elongates
eluviate1146953eluviate_
eluviated1345333eluviated
exuviates1945373exuviates
floriated1347023floriated
foliates11412753_foliates
glaciates1267343glaciates
illuviates1343813illuviates
labiates101011513_labiates
levigates1346493_levigates
levirates1247493_levirates
levitates1247863_levitates
locates93218813_lo_cates
loricates11310123_loricates
lovages1138033_lov_ages
lovats939073_lov_at_s
obviates1345153_obviates
opiates9312143__opiates
solvates11249673solv_ates
spoliates1138543spoliates

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.420425454.8
2DLD Change Limit148641486.08024447.5
3Display Results48480.0133692.3
 (SQL Overall)178691486.51327436.1
 
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.