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

425 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
deviser11421239(None) 
devise104215751devise_
devised123712561devised
devisee113812711devisee
devisers12339861devisers
devises114116761devises
devisor11357041devisor
reviser104114661reviser
adviser11135782adviser
debaser103510412debaser
decider114213182decider
defier105118652defi_er
defiler113911882defiler
definer114413772definer
defuser115110502defuser
deicer94114412de_icer
deliver113312242deliver
demise94618322demise_
demised113613682demised
demises103719562demises
demister11310222demister
denier74420692deni_er
denser74115192de_nser
deposer104011842deposer
derider93214972derider
deriver114213912deriver
desirer8310782desirer
despiser1136342despiser
device124512162device_
devices133212582devices
deviled124112182deviled
devisal1136912devisal
devisees12358282devisees
devisors12347252devisors
dewier104013462dewi_er
divider12278952divider
diviner11369882diviner
divisor11345572divisor
eviler94811892_eviler
levier94013872levi_er
paviser12489092paviser
reviler104314972reviler
revise94019742revise_
revised113815482revised
revisers113511932revisers
revises104220532revises
revisor10388732revisor
reviver134411372reviver
seiser65318342se_iser
advise10139223advise_
advised12136043advised
advisee11147153advisee
advisers12135003advisers
advises11138973advises
advisor11134163advisor
aegises8311373aegises
aerier64823153aeri_er
belier84423563beli_er
betise85616273betise_
betises94816123betises
beveler124010683beveler
bevies114017303bevi_es
brevier1237763brevi_er
bruiser9349573bruiser
caviler1249063caviler
ceiler84013963ce_iler
censer84516583ce_nser
cerise84822043cerise_
cerises94722253cerises
clevises1336903clevises
cruiser93410433cruiser
daiker115113033d_aiker
daises74318983d_aises
davies105020513davi_es
deader84220473de_ader
deafer104114813de_afer
deair65817193deai__r
deaired9411533deaired
dealer74122143de_aler
dearer74822803de_arer
debase94014473debase_
debased113310583debased
debasers11377903debasers
debases103814133debases
debater104114693debater
debited113311623debited
deboner103110483deboner
decayer13339353decayer
deceiver1436233deceiver
deciare10710663deciare
decibel1235993decibel
decide104116873decide_
decided124312423decided
deciders123510753deciders
decides114217653decides
decile94619213decile_
deciles104417723deciles
decipher1644423decipher
decker135215993de_cker
decliner113710843decliner
decoder113712293decoder
decoyer13348683decoyer
decreer10269123decreer
decrier102713553decrier
deedier93011593deedier
deemster1175713deemster
deeper93613503de_eper
deer56739023de___er
defacer132810363defacer
defamer132710323defamer
defer94619753de__fer
deffer134411303de_ffer
defied115016383defi_ed
defiers113913993defi_ers
defies104624053defi_es
defile105216663defile_
defiled124013103defiled
defilers12439473defilers
defiles114016843defiles
define104718143define_
defined123813823defined
definers124211193definers
defines114118683defines
defis96717503defis__
defter104215923de_fter
defuse105712723defuse_
defused125211093defused
defusers12487363defusers
defuses114814593defuses
degases93413103degases
degasser10325813degasser
dehisce13104273dehisce
dehisced1583683dehisced
dehisces1464713dehisces
deice84320033de_ice_
deiced104214483de_iced
deicers103612733de_icers
deices94119373de_ices
deifier113013123deifier
deism84116033de_is_m
deisms94411043de_isms
deist64633593de_is_t
deists74916433de_ists
deixises1635693deixises
delayer113010533delayer
delime9314043delime_
delimed11310723delimed
delimes10314193delimes
delis64928543delis__
delish105215613delis_h
delist74625053delis_t
delisted10310563delisted
delists84414173delists
delivers123310753delivers
delivery15286553delivery
delouser936363delouser
deluder9168333deluder
deluster936903deluster
delver104913493de_lver
demies94825803demi_es
demirep1236213demirep
demisters1249203demisters
demoses103815823demoses
dempster1355773dempster
demurer1037873demurer
denied84318633deni_ed
deniers84515183deni_ers
denies74729643deni_es
denimed1159233denimed
denizen1737663denizen
dense65923503de_nse_
denuder9167603denuder
depicter1356853depicter
depose94215763depose_
deposed113412023deposed
deposers11359243deposers
deposes103117213deposes
depriver1446293depriver
deride84420033deride_
derided102914253derided
deriders102411853deriders
derides93420853derides
deringer1038143deringer
derisory1245163derisory
derive103817043derive_
derived123912763derived
derivers123811363derivers
derives114017813derives
dermises112512023dermises
dernier83011943dernier
derrises93012783derrises
dervish1436983dervis_h
dervishes1644933dervishes
desert72725493de__sert
desex13311983de__sex
designer1036543designer
desilver12286503desilver
desire7415303desire_
desired9311983desired
desirers939263desirers
desires81316133desires
desist74818813desis_t
desisted1039783desisted
desists83611723desists
despise1038683despise_
despised1236923despised
despisers1245153despisers
despises1139433despises
dessert82916453de_ssert
detailer9268673detailer
detainer92910793detainer
deter65028043de__ter
detester9239683detester
deticker1545283deticker
devas96218883devas__
deveined1336673deveined
devel94217123dev__el
develed123611933develed
devest104418703deves_t
devested13239133devested
devests114410473devests
deviant11311313deviant
deviate11312713deviate
deviated13311043deviated
deviates12312733deviates
deviator1248313deviator
devil94714733devi__l
devilled1336743devilled
devilry1433973devilry
devils104412813devi_ls
deviltry1542983deviltry
devious1138523devious
devisals1245613devisals
devising133111523devising
devoice13347343devoice_
devoiced15276063devoiced
devoices14307413devoices
devoir1076033dev_oir
devote104513783devote_
devoted124111093devoted
devotee113811823devotee
devotes113713753devotes
devour1076703dev_our
devourer1235063devourer
devouter1235513devouter
devs86424033dev_s__
dewater112912423dewater
dewiest11312343dewiest
dexie134716893dexi_e_
dexies145018343dexi_es
dexter143810893de_xter
dicer85426423d__icer
dicier94416233dici_er
diker105524553d__iker
dimer85625603d__imer
diner65632903d__iner
direr64927073d__irer
diseur738843d__iseur
ditsier83010293ditsier
diver94827803d__iver
divide113410893divide_
divided13378593divided
dividers13257213dividers
divides123211453divides
divine103514463divine_
divined12329693divined
diviners12308353diviners
divines113514723divines
divisors12255693divisors
dopier93515923dopi_er
dorser74819183d_orser
doser66228563d__oser
dosser74417973d_osser
dossier83711693dossier
dotier73917033doti_er
douser75621633d_ouser
dovish1338103dovis_h
dowser104716083d_owser
dozier163611633dozi_er
drainer83012843drainer
dresser83611953dresser
dressier956863dressier
drier64423963d_ri_er
driver104714493d_river
duiker114110593d_uiker
easier64218463_easier
edgier8469723edgi_er
eelier64216463eeli_er
eerier64320023eeri_er
egises7312493_egises
eider64624743_e_ider
envier939673envi_er
epimer10109153_epimer
eraser64216333_eraser
evader1036813_evader
evener91010623_evener
ever77027693_ev__er
eviller1056673_eviller
evite85317683_evite_
evited104013143_evited
evites94916473_evites
evoker13467913_evoker
exiler134712183_exiler
fever115617953fev__er
geyser1036513ge_yser
heavier13429423heavi_er
heifer1238203he_ifer
heister103613623he_ister
idoliser945043idoliser
inviter104112313inviter
jivier16438613jivi_er
kaiser103610373_kaiser
keister113011573ke_ister
lavisher1445083lavisher
leaser65322673le_aser
leavier10319993leavi_er
leister73212753le_ister
lesser63514853le_sser
leveler10399903leveler
lever85125163lev__er
levied104111433levi_ed
leviers103510343levi_ers
levies93919863levi_es
levis85818553levis__
lewises1039133lewises
livier97514593livi_er
mavises122812993mavises
meister93114163me_ister
merises93421423merises
messier93412923messier
metier83517693meti_er
miser75430403__miser
nervier10298833nervi_er
never86218643nev__er
newsier10147223newsier
pavise114714803pavise_
pavisers13387443pavisers
pavises125315493pavises
peise75825773pe_ise_
peised94817683pe_ised
peises84125043pe_ises
pelvises1337273pelvises
penises9318193penises
peruser93511373peruser
poetiser1037313poetiser
poiser84217243_poiser
praiser93413943praiser
preciser123411663preciser
previse123713793previse_
prevised143611073prevised
previses133814283previses
previsor13116303previsor
raiser66620103_raiser
ravisher1465463ravisher
realiser82512563realiser
reciter94117263reciter
refiner105316913refiner
refuser104912783refuser
register939553register
reiver95318293re_iver
relier65826183reli_er
remise84221953remise_
remised103516843remised
remises93423483remises
repiner94816903repiner
reposer93715333reposer
rerise64325633rerise_
rerisen73613643rerisen
rerises73525883rerises
resider84615803resider
resister8311653resister
retirer74715013retirer
reveler104116343reveler
reverer103815833reverer
reverser113010483reverser
review1238693revi_ew
reviewer1434133reviewer
revile94921613revile_
reviled114417923reviled
revilers114011693revilers
reviles104421353reviles
revisal1038263revisal
revisit10311373revisit
revisors11379063revisors
revisory14306013revisory
revive124914823revive_
revived144211653revived
revivers14389633revivers
revives134715543revives
revoker14419193revoker
riser55431053__riser
seiner64622483se_iner
seise54727853se_ise_
seised74218123se_ised
seisers73816393se_isers
seises64026713se_ises
seisor63712333se_isor
seizer154114573se_izer
semises93916553semises
servicer1335263servicer
sever85426053sev__er
severer103511563severer
sexier13310683sexi_er
teaser65421523te_aser
tenser64919433te_nser
terser67317823te_rser
unwiser1037123unwiser
upriser9218763upriser
veiler93814353ve_iler
veiner94514753ve_iner
veliger1137313veliger
verier94620963veri_er
verser94516963ve_rser
vetiver1336103vetiver
vier75428153__vi_er
viler86324163__viler
viper105017303__viper
vise75632673__vise_
vised95518763__vised
vises84427773__vises
visor82512833__visor
vivider14265623vivider
wavier124613083wavi_er
weiner94214133we_iner
wiser85522803__wiser

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.1561145455.1
2DLD Change Limit1340274256.67320085.0
3Display Results4254250.1562724.4
 (SQL Overall)1786914256.98525582.1
 
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.