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

65 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
brevities144642(None) 
brevetcies1782202brevetcies
breviaries1564002breviaries
gravities1338302gravities
levities11310712_levities
privities14312042privities
amenities11310433amenities
arenites8917103arenit_es
aridities10911633aridities
beasties102514653b_easties
beauties10229523b_eauties
bedirties1275683b_edirties
bevies114017303b_ev__ies
bheesties1443923bheesties
braveries1439103braveries
breathes134212903bre_athes
breves115516423brev___es
breveted1435623brevet_ed
breveting1536263breveting
brevets12519393brevet__s
brevetted1543863brevetted
brevier1237763brev__ier
breviers1335923brevi_ers
brevity1534783brevit__y
breweries1447583breweries
brewises1337213brewi_ses
brewskies18132273brewskies
brinies93317913br__inies
brutifies1445713brutifies
calvities1438943calvities
cavities131412613_cavities
cecities12312043_cecities
crevices1536713crevi_ces
crudities1247743crudities
deities82621923_de_ities
eremites10312603eremit_es
evites94916473__evit_es
ferities111416713_ferities
heredities1447223heredities
lenities8315943_lenities
obesities1145843obesities
oralities91214123oralities
pretties10615133pre_tties
previses133814283previ_ses
previsits1446793previsits
probities13312653probities
rarities8316333_rarities
realities9316313_realities
realties8514853_realties
recites93524583_recit_es
reifies104218283_re_ifies
resites74027793_resit_es
reties65436193_re__ties
retitles83612593_retitles
reveries112518513_reveries
reviles104421353_revi_les
revises104220533_revi_ses
revisits1137423_revisits
revives134715543_revi_ves
revotes104716393_revot_es
serenities10411063serenities
suavities1248413suavities
treaties8316983tre_aties
trinities9313343trinities
verities111418043_verities

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 Limit148641656.84321721.6
3Display Results65650.0331969.7
 (SQL Overall)178691657.04925349.8
 
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.