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

197 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
deviant1131131(None) 
defiant11311921defiant
deviants1236731deviants
decant93524222de_cant
depaint10314592depaint
descant104315592descant
deviance1477082deviance
deviancy1754182deviancy
deviate11312712deviate
levant9314492lev_ant
mediant103516702mediant
reliant7319242reliant
affiant1348433affiant
alleviant1246143alleviant
avant86224663_av_ant
avian84616053_avian_
avians93711563_avians
bepaint11312183bepaint
bezant17814543be_zant
bezzant1746893bezzant
damiana1046563damiana
davit93424593davi__t
dealt65234283de__alt
dean56039483de__an_
deans66131393de__ans
deaving123814753deavi_ng
debit85727853debi__t
debutant1146183debutant
decane93818873de_cane
decants103514443de_cants
decent94023703de_cent
deciare10710663deciare
dedans85915073de_dans
deewan10267553deewan_
deewans11306903deewans
defang1137753de_fang
defat95426693de_fa_t
defeat103817163defea_t
defiance1477633defiance
defiantly1644153defiantly
deficit1339673deficit
define104718143defi_ne
defoliant1345203defoliant
deign74312803de_ign_
deigns8389983de_igns
deist64633593de_i_st
deking125614553deki_ng
delaine8314793delaine
delict94320333deli_ct
delight12610673delight
delimit10311733delimit
delist74625053deli_st
delving123711573delvi_ng
demand104314253de_mand
demast9517063de_mast
demean9510563demean_
demeans1039723demeans
dement93825153de_ment
demit84832303demi__t
demount1049743demount
denial74720513denia_l
denials84114133denials
dent57158413de___nt
deodand1035713deodand
depaints1136643depaints
depart94720563de_part
depict113514793depi_ct
deplane10311413deplane
derat65044083de_ra_t
desalt7518313de_salt
desand84812633de_sand
descants112910143descants
descent102616293descent
desiccant1444193desiccant
design8408933design_
designs9328313designs
desinent9312963desinent
desist74818813desi_st
desman9311693desman_
desmans1039003desmans
detain74617383detain_
detains83716093detains
detent73624483de_tent
detract101414633detract
deva85720983dev_a__
devas96218883dev_a_s
devein1039143devein_
deveins1138813deveins
devest104418703dev_est
deviances1566493deviances
deviated13311043deviated
deviates12312733deviates
deviating14311083deviating
deviator1248313deviator
device124512163devi_ce
devices133212583devices
devil94714733devi__l
deviled124112183deviled
deviling1311812853deviling
devilment1547713devilment
devilry1433973devilry
devils104412813devi_ls
devious1138523devious
devisal1136913devisal
devisals1245613devisals
devise104215753devi_se
devised123712563devised
devisee113812713devisee
deviser114212393deviser
devises114116763devises
devising133111523devising
devisor11357043devisor
devon95113683dev_on_
devonian1244813devonian_
devons104512253dev_ons
devout10712993dev_out
dewan95718043de_wan_
dewans105215143de_wans
dewiest11312343dewiest
dewing114115703dewi_ng
dezinc1836053dezi_nc
dint56759053d__i_nt
discant103017263discant
distant83519953distant
divan96114843div_an_
divans104612393div_ans
divine103514463divi_ne
diving113717953divi_ng
dominant1149523dominant
dopant9316133d_opant
dormant102814373dormant
durian7312003durian_
durians839573durians
elint55436473_eli_nt
eluant6315093_eluant
errant6618733_errant
event85924443_ev_ent
evict104417143_evi_ct
evident1139993_evident
extant132714753_extant
feint84732253fe_i_nt
gelant72821673ge_lant
gellant83214053gellant
giant65430593__giant
heliast10312073heliast
hesitant1149083hesitant
jessant1438443jessant
leant56737783le__ant
lenient7313843lenient
levants1037723lev_ants
levin84816413levi_n_
levins94514653levi_ns
meant76537213me__ant
median94117543median_
medians103214213medians
mediants11299493mediants
medicant13910833medicant
mesian84315503mesian_
nondeviant1454743nondeviant
peasant9314923peasant
peccant13311733peccant
pedant9319493pe_dant
pendant10314853pendant
pennant9312493pennant
perianth1348553perianth
periapt11313413periapt
pliant83918823_pliant
radiant82817133radiant
reboant9315093reboant
recant83228683re_cant
regnant8312843regnant
regrant8317323regrant
remint85329983remi_nt
remnant9312643remnant
repaint9318363repaint
replant93318533replant
reptant92817073reptant
retint65633443reti_nt
retirant8313593retirant
revenant11410283revenant
revisit10311373revisit
riant55833153__riant
savant9416043sav_ant
sealant73118303sealant
seawant103613413seawant
secant84023293se_cant
sejant133114483se_jant
sejeant1489723sejeant
servant10313633servant
sextant142911963sextant
tenant6322473te_nant
valiant10314623valiant
variant10316803variant
verdant11313293verdant
versant10313833versant
vesicant1347503vesicant
viand9511073__viand

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271976.01622278.4
3Display Results1971970.0802462.5
 (SQL Overall)1786911976.50227482.5
 
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.