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 “dieses” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 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
dieses7521869(None) 
dienes75719901dienes
diesel74410401diesel
diesels8429141diesels
diesis74013491diesis
disses75225961disses
beses75830722_beses
biases84618432biases
birses84717732birses
bises75435622bi_ses
cyeses11510122cyeses
daises74318982daises
dees56356632d_e_es
deices94119372deices
deisms94411042deisms
deists74916432deists
dekes105224452d_ekes
deles65139252d_eles
demes86032692d_emes
denes65639722d_enes
desex13311982d_esex
desks105913072d_esks
dexes135224512d_exes
dices86434242di_ces
didies84621832didies
didoes85716962didoes
diene65720132diene_
diereses938692diereses
dies55653522di__es
diester83013682diester
diesters92513592diesters
dieted83115492dieted
dieter73516772dieter
dieters83216422dieters
diets66026642die_ts
digests93610612digests
dikes105831332di_kes
dimes85833042di_mes
dines66449152di_nes
dinges83825422dinges
dioceses1137112dioceses
diodes83915782diodes
dipsas9359892dipsas
dipsos95310052dipsos
dirges84915102dirges
discs85316262di_scs
diseases92415812diseases
diseuses93112762diseuses
dishes104622652dishes
disks105417472di_sks
dismes95617672dismes
diss56434482di_s_s
dissed85220182dissed
disuses84015412disuses
dites66339152di_tes
ditzes163212422ditzes
diureses936452diureses
dives95832402di_ves
divests114510932divests
doses65938502d_oses
dosses76126272dosses
douses74928932douses
dowses105718302dowses
drees65628522dre_es
dress65319832dres_s
dresses83716172dresses
druses75517252druses
dulses73913652dulses
emeses86114962emeses
eses45336102__eses
hisses94719352hisses
kineses113111252kineses
kisses104217332kisses
leses54930812_leses
lieges74113442lieges
mimeses1139072mimeses
mioses84318852mioses
mises74740562mi_ses
misses85130872misses
nieces84112712nieces
nieves94311292nieves
peises84125042peises
pieces104217272pieces
pisses84525082pisses
rinses64720382rinses
rises55244042ri_ses
seises64026712seises
sieges73816832sieges
sieves93216002sieves
sises55233832si_ses
sisses64520602sisses
theses96517972theses
tmeses85712242tmeses
vises84427772vi_ses
wises85633192wi_ses
wisses94619602wisses
yeses85119322_yeses

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit82551972.65631080.9
3Display Results97970.0303233.3
 (SQL Overall)178691972.79663909.5
 
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.