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

141 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
decrials113713(None) 
decrial10310321decrial_
aerials74017552ae_rials
decals93717712dec__als
decimals1345862decimals
decretals1245092decretals
decriers11299732decriers
decries103319802decri_es
denials84114132de_nials
deprivals1543532deprivals
derails84216392de_rails
fecials123510332fec_ials
retrials8510822retrials
serials73919742se_rials
accruals1243703accruals
aecial84817313aec_ial_
aerial64625713ae_rial_
becrawls1543623becrawls
becrimes1467073becrimes
bedrails1136293bedrails
burials93612083_burials
cereals9313173ce_reals
cerias83321973ce_ria_s
craals84113303__craals
deals65435343de___als
dearies83526273deari_es
debrides1268723debrides
debriefs1433533debriefs
debris93311493debri__s
decadal1137243decadal_
decafs124010883dec__afs
decal85523233dec__al_
decanal1038113decanal_
decays124612913dec__ays
deceits102810883decei_ts
deceives1437903deceives
decennials1353343decennials
deciare10710663dec_iare
deciares11510633dec_iares
decibels1344523decibels
decides114217653dec_ides
decile94619213dec_i_le
deciles104417713dec_iles
decimal1238083decimal_
deckels14367363dec_kels
deckings16346673deckings
declaims1345823declaims
declass1038733dec_lass
declaws1336253dec_laws
declines113315793declines
decrease1136563decrease
decreases1237223decreases
decreers11277623decreers
decrees102513123decr_ees
decretal1146353decretal_
decried112612853decri_ed
decrier102713553decri_er
decrowns14265063decrowns
decrypts1642943decrypts
decuries11312223decuri_es
decurions1246023decurions
deferrals1343683deferrals
defrags1236193defr_ags
defrayals1642283defrayals
defrays1436113defr_ays
deils65722863de__i_ls
demurrals1243023demurrals
denial74720513de_nial_
dentals83915393de_ntals
dentils84115583denti_ls
deposals1145433deposals
deprival1444603deprival_
deprives1438393deprives
derail74218813de_rail_
derats74625063de_r_ats
derays105514253de_r_ays
derides93420853de_rides
derives114017813de_rives
dermal93614343de_rmal_
dermas94116813de_rma_s
derricks1544433derricks
derries83124623derri_es
derris73615273derri__s
derrises93012783derrises
describes1446003describes
descriers1245693descriers
descries11311923descri_es
despisals1243503despisals
details84214043detai_ls
detrains9411753detrains
detrital946573detrital_
detritus945473detritus
deverbals1544103deverbals
devils104412813de_vi_ls
devisals1245613devisals
dials64925343d___ials
diurnals943803diurnals
dorsals84110843d_orsals
drails74716953d__rails
drills74414203d__rills
durians839573d_urians
espials937093_espials
facials123310743fac_ials
fecial114714623fec_ial_
ferals94216643fe_r_als
ferial94621253fe_rial_
ferias95020393fe_ria_s
fetials103711743fe_tials
gharials1245123gharials
herbals122710603he_rbals
kerrias11289513kerria_s
lacrimals1342913lacrimals
medials103914733me_dials
memorials1346533memorials
menials94015683me_nials
mercurials1453063mercurials
perils84121853pe_ri_ls
pretrials1158143pretrials
reburials1143933reburials
recitals1039763recitals
recoals94214623rec_oals
recoils93814873recoi_ls
recusals1056393recusals
redials84416883re_dials
redrills956083redrills
reprisals1144563reprisals
retrial7615553retrial_
rials55026673___rials
sacrals93311793sacr_als
seconals1047053seconals
sectorials1286523sectorials
serails73318363se_rails
serial64625853se_rial_
servals103410743se_rvals
socials999633soc_ials
specials1238033spec_ials
tertials8510073tertials
trials64319883__trials
uncials92510523unc_ials
urials64415193__urials
verbals121910733ve_rbals

Search took 10 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 Limit1461621419.12316021.3
3Display Results1411410.0463065.2
 (SQL Overall)1786911419.32519162.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.