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

142 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
dimwit123795(None) 
dimwits1344511dimwits
dammit11311132dammit
demit84832302dem_it
digit73825272di_git
dimity12310472dim_ity
dimout9414242dimout
dixit134420592di_xit
limit73126342lim_it
nitwit938592nitwit
admit8319493adm_it
ambit94223713_ambit
armpit10811093armpit
bigwig1333343bigwig
binit76431583bi_nit
comfit133112423comfit
commit124016703commit
dacoit9415453dacoit
daimio937463daim_io
dakoit11310353dakoit
davit93424593d_avit
dawt85435943d_aw_t
daylit10512493daylit
debit85727853d_ebit
deceit93018213deceit
delimit10311733delim_it
demast9517063demast
dement93825153dement
demerit10314993demerit
demic105119193dem_ic
demits94918073dem_its
diacid10310633diacid
dialist8517763dialist
diamin9312523diamin
diapir9357113diapir
diarist8517113diarist
diazin1639163diazin
dicast9315573dicast
dickie133913113dickie
dicot85429093di_cot
didact10711203didact
didie74120563di_die
didst74619613di_dst
diesis74013493diesis
diet57357533di__et
digest84019623digest
dight104027003di_ght
digits84114533di_gits
diglot83014333diglot
dignity1236453dignity
dikdik1152613dikdik
diktat11310693diktat
dim68146493dim___
dime76237643dim__e
dimer85625603dim_er
dimeric12310013dimeric
dimers94321093dimers
dimes85833043dim_es
dimly114913483dim_ly
dimmed124110323dimmed
dimmer114112613dimmer
dimmest1249253dimmest
dimming13339593dimming
dimouts1037893dimouts
dimple113512793dimple
dimply14339743dimply
dims75435023dim__s
dimwitted1642293dimwitted
dint56759053di__nt
diorite8314913diorite
dioxid1568393dioxid
dioxin14118783dioxin
dipnet91317473dipnet
dipshit1347993dipshit
dipt77339323di__pt
diquat1639763diquat
direct93817333direct
direst75024243direst
dirt55550383di__rt
disci85815023disci_
dismast10311233dismast
distil73616433distil
dit47071333d___it
divert103922813divert
divest106820073divest
divot95723073di_vot
diwan95712553di_wan
dixits144210313di_xits
doit56347853d__oit
domain9511323domain
domic104317243dom_ic
dowie94721143d_owie
droit65127123d_roit
duit56241583d__uit
emit65438423_em_it
fixit154819303fi_xit
gambit114714213gambit
gimlet93716663gimlet
gimmie11298183gimmie
godwit1137513godwit
imid76122293_im_id
immix1635033_immix
impi85415793_impi_
impis96213853_impis
iwis77117013_i_wis
jimmie17376473jimmie
kiwi113211803ki_wi_
kiwis12328583ki_wis
licit74327683li_cit
limbi96513813limbi_
limbic12528743limbic
limits82514143lim_its
limnic10418843limnic
limpet103518633limpet
limpid11389753limpid
mimic111414323mim_ic
misfit112813833misfit
mishit112618203mishit
mislit83019693mislit
miswrit1249413miswrit
nimbi94910313nimbi_
nitwits1035053nitwits
omit65337373_om_it
outwit93014593outwit
peewit111110903peewit
pewit104622793_pewit
pipit95224873pi_pit
remit75737223rem_it
simlin8311733simlin
smit65138413_sm_it
summit10311543summit
tidbit938493tidbit
timid84815733tim_id
titbit839823titbit
tomtit8413853tomtit
twit76329063__twit
unwit84417523_unwit
visit8320963vi_sit
vomit102622573vom_it
wimmin1336153wimmin
wit66563773___wit
zizit13313273zi_zit

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161424.72023880.5
3Display Results1421420.0463087.0
 (SQL Overall)1786911425.14234751.3
 
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.