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

87 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
crudities124774(None) 
crudites1137761crudit_es
acridities1348292acridities
aridities10911632aridities
crucifies1646122crucifies
cruelties1144892cruelties
nudities939682_nudities
acidities12810183acidities
acuities10312453acu_ities
auditees946463_auditees
auditives1345723_auditives
avidities13107613avidities
brevities1446423brevities
brutifies1445713brutifies
caducities1544893caducities
calvities1438943calvities
canities101519263c_anities
carditis11310223carditi_s
carditises1346963carditises
caudates11310263caudat_es
caudices13337343caudi_ces
cavities131412613c_avities
cecities12312043c_ecities
cerusites1146523cerusit_es
charities14312743charities
chedites1438263chedit_es
circuities1446913circuities
cities84524853c___ities
clarities11312483clarities
codifies1439643c_odifies
comities12317793c_omities
cordites11314623cordit_es
counties10316283cou_nties
credited1238253credit_ed
crediting1338843crediting
creditors1245863creditors
credits1039973credit__s
credulities1444133credulities
crinites10612763crinit_es
critics112811093cr__itics
crossties1139013crossties
crucibles1543743crucibles
crucified1744683crucified
crucifier1644313crucifier
crucifiers1743073crucifiers
crucifixes2452093crucifixes
cruddier1244153crud_dier
cruddiest1334453crud_diest
crudes96218623crud___es
crudity1336043crudit__y
cruises93514443cru_i_ses
crummies1437643cru_mmies
crustier10259533cru_stier
crustiest112410053cru_stiest
cuddies113313263c_ud_dies
cupidities1545973cupidities
curites93919863c_urit_es
cuties84927363c_u__ties
cutties93118843c_u_tties
equities17310773equ_ities
erudite838483erudit_e_
erudition1046173erudition
eruditions1146103eruditions
fluidities1445223fluidities
fruitier1136593fru_itier
fruitiest1237383fru_itiest
furmities1447543furmities
gravities1338303gravities
heredities1447223heredities
oddities1046603_oddities
oralities91214123oralities
paucities1348503paucities
privities14312043privities
probities13312653probities
prodigies1346953prodigies
pruderies1247873pruderies
purities10316283_purities
rarities8316333_rarities
raucities1148163raucities
ruderies9311333_ruderies
scrutinies1264043scrutinies
trinities9313343trinities
triunities1046103triunities
trusties82712853tru_sties
unities72520153__unities
viduities1346113viduities
viridities14106903viridities

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.1701051123.5
2DLD Change Limit148641877.25320493.7
3Display Results87870.0461891.3
 (SQL Overall)178691877.46923924.4
 
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.