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

147 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
deixises163569(None) 
deicides1249302deicides
deifies113317452deifi_es
deities82621922deiti_es
deixis1437242deixi__s
demises103719562de_mises
dermises112512022dermises
derrises93012782derrises
despises1139432despises
devises114116762de_vises
dexies145018342de_xi_es
adenitises1145733adenitises
aegises8311373ae_gises
axises134413993__axises
betises94816123be_tises
cercises12410933cercises
cerises94722253ce_rises
dailies84219263daili_es
dairies84217733dairi_es
daises74318983d__aises
daisies84217093daisi_es
dearies83526273deari_es
debases103814133de_bases
debrides1268723debrides
debruises1243633debruises
deceases11410153deceases
deceives1437903deceives
decides114217653de_cides
deciles104417723de_ciles
declines113315803declines
decries103319813decri_es
defenses1237913defenses
defies104624053de_fi_es
defiles114016843de_files
defines114118683de_fines
defuses114814593de_fuses
degases93413103de_gases
degasses10278363degasses
dehisces1464713de_hisces
deices94119373de__ices
deicide1149403deicide_
deified123112413deifi_ed
deifier113013123deifi_er
deifiers12348993deifiers
deionizes1958213deionizes
deisms94411043de__isms
deists74916433de__ists
delaines9312963delaines
delimes10314193de_limes
delists84414173de_lists
dellies83622213delli_es
delouses9310013delouses
demies94825803de_mi_es
demise94618323de_mise_
demised113613683de_mised
demonises12311093demonises
demoses103815833de_moses
denies74729643de_ni_es
dentines93418403dentines
dentists939263dentists
deposes103117213de_poses
deprives1438393deprives
depsides1238503depsides
derbies103016053derbi_es
derides93420853de_rides
derives114017813de_rives
derries83124623derri_es
dervishes1644933dervishes
desires81316133de_sires
desists83611723de_sists
despise1038683despise_
despised1236933despised
despiser1136343despiser
despisers1245153despisers
despites11410313despites
destines93619663destines
devices133212583de_vices
devise104215753de_vise_
devised123712563de_vised
devisee113812713de_visee
devisees12358283de_visees
deviser114212393de_viser
devisers12339863de_visers
devoices14307413devoices
dexes135224513de_x__es
dexie134716893de_xi_e_
didies84621833d_idi_es
diereses938693diereses
dieses75218693d_i_eses
dioxides1756203dioxides
disses75225963d_i_sses
disuses84015413d_isuses
divides123211453d_ivides
divines113514723d_ivines
divinises1367013divinises
dixits144210313d_ixi_ts
doilies84017363doili_es
doxies143917853d_oxi_es
edifices1454863edifices
edifies113012283edifi_es
egises7312493_e_gises
excises1638933_excises
exiles134816403_e_xiles
exines135715803_e_xines
exists134710913_e_xists
feminises14229753feminises
finises10312903_finises
genoises939253genoises
heinies102514543heini_es
hexoses17228893he_xoses
ibises83610543__ibises
idealises1047783idealises
irises64221173__irises
iritises839983iritises
kermises14248313kermises
laicises1039573laicises
lewises1039133le_wises
liaises7311053_liaises
meinies92516073meini_es
meioses9310833mei_oses
merises93421423me_rises
mitises9315543_mitises
nexuses1436743ne_xuses
nixies135313873_nixi_es
otitises839163otitises
oxidises1644833oxidises
peises84125043pe__ises
pelvises1337273pelvises
penises9318193pe_nises
pixies154915513_pixi_es
praxises1739063praxises
realises82420183realises
reifies104218283reifi_es
remises93423483re_mises
reprises102615463reprises
reraises8415643reraises
rerises73525883re_rises
revises104220543re_vises
rexines144719153re_xines
seises64026713se__ises
semises93916553se_mises
sexisms16226223se_xisms
sexists14267673se_xists
tennises82810133tennises
texases1437573te_xases
utilises848973utilises
uveitises1243643uveitises

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621477.45319611.2
3Display Results1471470.0632333.3
 (SQL Overall)1786911477.93922508.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.