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

234 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
devoirs117578(None) 
devoir1076031devoir_
devours1166641devours
bevors111610342bevo_rs
deairs74013782de_airs
decors94017772deco_rs
detours858042detours
deveins1138812deveins
devils104412812dev_ils
devious1138522devious
devoice13347342devoice
devoices14307412devoices
devoid1189362devoi_d
devons104512252devo_ns
devotes113713752devotes
devour1076702devour_
dyvours1453182dyvours
memoirs1136802memoirs
adenoids1056863adenoids
avoids104410203_avoids
bestirs9311133bestirs
bevies114017303bev_ies
bevomits1543463bevomits
bevor101510813bevo_r_
bezoars1836793bezoars
ceboids1237653ceboids
choirs114911883_choirs
coirs75221053__coirs
dacoits1079073dacoits
dakoits1245293dakoits
davies105020513dav_ies
davits104012363dav_its
deair65817193de_air_
dealers84118613dealers
dearies83526273dearies
dears65736883de__ars
debars94218043de_bars
debits94214503de_bits
deboners11268113deboners
debones103315113debones
debris93311493debri_s
debtors1038533debtors
deceits102810883deceits
deckers144413833deckers
decocts1237833decocts
decoders122810413decoders
decodes113914983decodes
decolors1187713decolors
decor84717573deco_r_
decos85522123deco__s
decoyers14287713decoyers
decoys123911283deco_ys
decriers11299733decriers
decries103319803decries
deers64930523de__ers
defers105116943de_fers
defiers113913993defiers
defies104624053de_fies
defis96717503de_fi_s
defoams1336193defoams
defocus1335283defocus
defogs1156683defo_gs
deform1259623defo_rm
deforms1337803deforms
dehorn10439653deho_rn
dehorns11428363dehorns
dehort104618103deho_rt
dehorts11379773dehorts
deicers103612733deicers
deifiers12348993deifiers
deifies113317453deifies
deils65722863de__ils
deities82621923deities
deixis1437243deixi_s
delis64928543de_li_s
dellies83622213dellies
deltoids1045483deltoids
delvers113411993delvers
demies94825803de_mies
demits94918073de_mits
demobs11429483demo_bs
demoing11311753demoing
demons94917723demo_ns
demos86022993demo__s
demoses103815823demoses
demotes104717673demotes
demotics1338753demotics
demurs939773de_murs
denars74621433de_nars
deniers84515183deniers
denies74729643de_nies
denims95214323de_nims
denotes83817003denotes
dentils84115583dentils
dentins83419223dentins
deodars937623deodars
depones103717093depones
deport94922393depo_rt
deports105012883deports
deposers11359243deposers
deposes103117213deposes
deposits1138843deposits
depots94716343depo_ts
derails84216393derails
derbies103016053derbies
dermis94717163dermi_s
dermoids1246163dermoids
derries83124623derries
derris73615273derri_s
desire7415303de_sire
desires81316133de_sires
desmids1166603desmids
desmoids1244973desmoids
desorb95210203deso_rb
desorbs10437713desorbs
despairs1144943despairs
despoils1145623despoils
details84214043details
detains83716093detains
deters74724683de_ters
detour778193detour_
detoxes1538803detoxes
devas96218883dev__as
devein1039143devei_n
devels104313903dev_els
devests114410473devests
device124512163dev_ice
devices133212583devices
devil94714733dev_i_l
devilry1433973devilry
devise104215753dev_ise
devisers12339863devisers
devises114116763devises
devisors12347253devisors
devoiced15276063devoiced
devolve14316063devolve
devolves15286263devolves
devon95113683devo__n
devonian1244813devonian
devote104513783devo_te
devoted124111093devoted
devotee113811823devotee
devotees12286283devotees
devoting1338823devoting
devotion1256763devotion
devotions1356593devotions
devoured1335723devoured
devourer1235063devourer
devourers1344093devourers
devout10712993devo_ut
devs86424033dev___s
dewars105117073de_wars
dewools1145593dewools
deworm1249533dewo_rm
deworms1338033deworms
dexies145018343de_xies
diapirs10347643diapirs
divers105024963div_ers
divots104712203divo_ts
divvies1457663divvies
doers65225713d__oers
doits66223673d__oits
dolors75115313dolo_rs
dolours8438823dolours
donors75115793dono_rs
doors65022133d__oors
dorrs65520593d__orrs
dors56747603d__o_rs
droids84712583d_roids
droits74314313d_roits
drovers115212643drovers
dyvour1393343dyvour_
eloins65419383_eloins
emirs76116163_e_mirs
envois988703envoi_s
evils84114263_ev_ils
evokers14386793_evokers
evokes13459683_evokes
favors124211403favo_rs
favours13437093favours
fervors1336233fervo_rs
fervours1453053fervours
fetors91014473feto_rs
fevers125414893fev_ers
geoids8369843ge_oids
haviors1347383haviors
heirs85618563he__irs
heroics122912003heroics
heroins103518013heroins
kefirs13396653ke_firs
keirs95313673ke__irs
keloids1288663keloids
kevils13358333kev_ils
levers94621323lev_ers
leviers103510343leviers
levies93919863lev_ies
levins94514653lev_ins
levis85818553lev_i_s
meloids10911453meloids
memoir1037213memoir_
menhirs1235913menhirs
nevoid1098793nevoi_d
noirs55615463__noirs
ovoids10456923_ovoids
paviors1237603paviors
reboils94111723reboils
recoils93814873recoils
recoins94019243recoins
rejoins143111383rejoins
renvois1036503renvoi_s
reoils64516873re_oils
reovirus1143423reovirus
repairs9319973repairs
repours9310233repours
revers94529633rev_ers
revoice12319183revoice
revoices13278993revoices
revokers15366753revokers
revokes144212503revokes
revolts1038893revolts
revotes104716393revotes
saviors1058993saviors
savors95616103savo_rs
savours10389343savours
seniors73413623seniors
senors63620793seno_rs
severs94121123sev_ers
tenors63217753teno_rs
tenours72610073tenours
vairs85019133__vairs
velours10278083velours
vetoers10359473vetoers
voids95414673__voids
weirs84316493we__irs

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 Filter1786911340270.423422437.4
2DLD Change Limit1340272346.64020184.8
3Display Results2342340.0802925.0
 (SQL Overall)1786912347.14325016.2
 
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.