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

142 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
deviants123673(None) 
deviant11311311deviant_
decants103514442de_cants
defiant11311922defiant_
depaints1136642depaints
descants112910142descants
deviance1477082deviance
deviances1566492deviances
deviancy1754182deviancy
deviate11312712devia_te
deviates12312732deviates
levants1037722lev_ants
mediants11299492mediants
affiants1445233affiants
alleviants1353413alleviants
avians93711563_avian_s
bepaints1235113bepaints
bezants1877343be_zants
bezzants1843643bezzants
damianas1155573damianas
davits104012363davi__ts
deans66131393de__an_s
debits94214503debi__ts
debutants1243713debutants
decanes103118913de_canes
decant93524223de_cant_
deciares11510633deciares
dedans85915073de_dan_s
deewans11306903deewan_s
defangs1235363de_fangs
defats105114553de_fa_ts
defeats113511233defea_ts
defiance1477633defiance
defiances1557033defiances
defiantly1644153defiantly
deficits1447273deficits
defines114118683defi_nes
defoliants1442933defoliants
deigns8389983de_ign_s
deists74916433de_i_sts
delaines9312963delaines
delicts104012253deli_cts
delights1347333delights
delimits1137573delimits
delists84414173deli_sts
demands114311413de_mands
demasts1089223de_masts
demeans1039713demean_s
dements103016623de_ments
demits94918073demi__ts
demounts1135473demounts
denials84114133denia_ls
dents65031803de___nts
deodands1144603deodands
depaint10314593depaint_
departs104310683de_parts
depicts12358463depi_cts
deplanes11311213deplanes
derats74625063de_ra_ts
desalts839573de_salts
desands94810163de_sands
descant104315583descant_
descents112511203descents
desiccants1542663desiccants
designs9328313design_s
desists83611723desi_sts
desmans1039003desman_s
detains83716093detain_s
detents83615153de_tents
detracts11138833detracts
devas96218883dev_a__s
deveins1138803devein_s
devests114410473dev_ests
deviancies1644593deviancies
deviated13311043deviated
deviator1248313deviator
deviators1358533deviators
devices133212583devi_ces
devilments1646383devilments
devils104412813devi__ls
devious1138523devi_ous
devisals1245613devisals
devisees12358283devisees
devisers12339863devisers
devises114116763devi_ses
devisors12347253devisors
devons104512253dev_on_s
dewans105215143de_wan_s
dezincs1933753dezi_ncs
dints67431313d__i_nts
discants112912023discants
divans104612393div_an_s
divines113514723divi_nes
dominants1245953dominants
dopants1038433d_opants
durians839573durian_s
elints65816423_eli_nts
eluants737583_eluants
errants7410643_errants
events94814073_ev_ents
evicts11368553_evi_cts
feints94813873fe_i_nts
gelants82611443ge_lants
gellants9308283gellants
giants74713503__giants
heliasts1136103heliasts
levant9314493lev_ant_
levins94514653levi_n_s
medians103214213median_s
mediant103516703mediant_
medicants1466783medicants
peasants1038263peasants
pedants10310113pe_dants
pendants1139093pendants
pennants1037063pennants
perianth1348553perianth
perianths1445473perianths
periapts1237273periapts
radiants9259443radiants
recants93217093re_cants
regrants9310013regrants
reliant7319243reliant_
remints95117293remi_nts
remnants1036843remnants
repaints1038483repaints
replants102811243replants
retints74717013reti_nts
retirants947323retirants
revenants1246173revenants
revisits1137423revisits
savants1038653sav_ants
sealants82610743sealants
seawants11337973seawants
secants93413893se_cants
servants1137993servants
sextants15287383sextants
tenants7311013te_nants
valiants1137793valiants
variants1139203variants
versants1137783versants
vesicants1444753vesicants
viands1047813__viands

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 Limit1461621427.81318707.5
3Display Results1421420.0602366.7
 (SQL Overall)1786911428.02922255.7
 
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.