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 “banality” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

101 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
banality133876(None) 
anality10313631_anality
anility10312722_anility
banalize191010932banalize
banally1249222banal_ly
carnality1447592carnality
fatality1438442fatality
finality1448342finality
nasality1146652nasality
natality1139192natality
penality13310712penality
tonality1139792tonality
venality1438682venality
ability12311443_ability
agility1148653_agility
analcite1049333_analcite
anally9513503_anal_ly
analogy11177843_analogy
analyte10158813_analyte
animality1447803_animality
annuity1045543_annuity
atonality1247073atonality
aurality1139223aurality
axiality1856763axiality
baalim1038473ba_ali_m
baalism11310593ba_alism
backlit15911903backlit_
bakelite1447253bakelite
banal75925993banal___
banalities1249813banalities
banalized21118703banalized
banalizes201210093banalizes
bandit93821133ban_dit_
bandito103710043ban_dito
banditry1444123ban_ditry
bandits103814793ban_dits
bankability2245233bankability
bankit123617043ban_kit_
bankits133410153ban_kits
bantling112611993bantling
banty106624003ban___ty
barbarity1645063barbarity
basally1237963basal_ly
basalt83519583basal_t_
basaltic1245153basaltic
basalts9358963basal_ts
basicity1546313basicity
brutality1444123brutality
calamity1547753calamity
canaling112016403canaling
canalise10816213canalise
canalize19914493canalize
caninity1338063caninity
capacity1746023capacity
causality1445323causality
dentality1348473dentality
duality1147963_duality
equality2046993equality
facility1638243facility
fayalite1447053fayalite
geniality1347163geniality
ideality1247153ideality
inanity1039503_inanity
labiality1446363labiality
lability13710833lability
lanosity1146353lanosity
legality1237623legality
lineality1246423lineality
locality13148433locality
mammality1544273mammality
manlily1238743man_lily
mentality1449133mentality
minacity1547363minacity
modality14117643modality
molality13118363molality
morality131110333morality
nodality12127423nodality
orality101111683_orality
ovality1377593_ovality
penalty1267743penal_ty
planarity1445323planarity
quality1938563_quality
rapacity1544983rapacity
rascality1445993rascality
reality10313573_reality
regality1249313regality
rurality1137403rurality
sagacity1445243sagacity
salacity1347853salacity
sanctity1345593sanctity
sanity9316203san__ity
senility1139683senility
sodality12127323sodality
tantalite91010853tantalite
tenacity1347113tenacity
totality1139373totality
vagility1546323vagility
vanity12311933van__ity
veniality1547593veniality
vitality1458113vitality
vocality16137933vocality

Search took 9 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621018.31317582.3
3Display Results1011010.0462195.7
 (SQL Overall)1786911018.51520985.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.