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

158 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
ankush1311443(None) 
ankus91410681ankus_
ablush1147222ablush
ambush1336102ambush
anguish11117632anguish
ankh111114412ank__h
ankhs12116722ankhs_
ankuses1148202ankuses
ankushes1544582ankushes
anus47131112an_us_
inrush936512inrush
onrush935342onrush
rankish14510382rankish
abash106016513a_bash
abuse77119563a_buse
accuse103411033accuse
adjust1447173adjust
adust64117453a_dust
aeneus61111143aeneus_
afresh1255503afresh
aguish1059283aguish
amus65529613a_mus_
amuse75920833a_muse
anarch11310393anarch
anas46649863an_as_
anchusa1244333anchusa
ands57833613an_ds_
anenst63514983anenst
anes45255933an_es_
angas65827983angas_
angst6415493an_gst
anils56326723anils_
animus84211613animus_
anis45746463an_is_
anise55129703an_ise
ankle95220253ank_le
ankled114313473ankled
ankles104818383ankles
anklet105618733anklet
anlas55626933anlas_
annas55824883annas_
annual64710703annual
annul55813383annu_l
annuli6459053annuli
annuls64711733annuls
anoas57226493anoas_
ansa45927773an__sa
antas55432033antas_
antes56334323antes_
antis55033313antis_
ants47243473an_ts_
antsy85712793an_tsy
anuses66218773an_uses
apish105116633a_pish
arcus76918863arcus_
argus66716543argus_
arkose104911343arkose
arks85936873ark_s_
arouse65019983arouse
ascus75013583ascus_
ash67944603a___sh
askos95011773askos_
asks85721213ask_s_
aslosh966233aslosh
aspish114810333aspish
august739203august
auks85525263auk_s_
avouch1434833avouch
awash116613163a_wash
backrush1944103backrush
banish111416043ban_ish
banks115527903bank_s_
blush105115313_blush
brush105917473_brush
bush96630713__bush
cantus85117763cantus_
choush14549063choush
crankish1736513crankish
crush106815993_crush
danish101513793dan_ish
dankest122611673dankest
darkish1537943darkish
encash11276943encash
endash10297123endash
enmesh1134893enmesh
enough1045753enough
flush115116073_flush
gawkish1835833gawkish
gnash9449833gn_ash
gnus56518003gn_us_
gush85424003__gush
hagbush1642623hagbush
haikus13538293haikus_
hakus125114113hakus_
hanks126226863hank_s_
hawkish2036553hawkish
hush105224113__hush
incus73315053incus_
incuse83513573incuse
infuse93110573infuse
inks86926503ink_s_
inmesh1134853inmesh
jukus16398673jukus_
kanzus1944603kanzus_
knish1238603kn_ish
languish12136253languish
lankest112714113lankest
larkish1439083larkish
lush75327693__lush
mannish121710693mannish
manus75924923man_us_
mawkish1935823mawkish
maybush1742453maybush
monkish1638243monkish
mush94929123__mush
nosh76223543_n_osh
nous46136983_nous_
nus37939393_n_us_
onus45826813on_us_
panfish15229973panfish
pinkish16279113pinkish
plush105614713_plush
prankish1737023prankish
punkish16257693punkish
push95526623__push
qurush1835503qurush
rakish134313963rakish
rakus94413673rakus_
rankest112713813rankest
ranks95225733rank_s_
rush76628183__rush
shush113812543_shush
skosh12407263_skosh
slush85316573_slush
smush104410583_smush
snash84815673sn_ash
sneesh945893sneesh
squush1833993squush
tankas104613763tankas_
tanks94624733tank_s_
tannish101610573tannish
tarbush1234173tarbush
thrush12257483thrush
tush74523903__tush
unaus53216573unaus_
unbusy1135213unbusy
uncus74014983uncus_
unhusk1334263unhusk
unjust1337873unjust
unlash938793unlash
unmesh1145793unmesh
unwish1239093unwish
uprush1135783uprush
vanish121513203van_ish
vanquish2343543vanquish
wanks126124483wank_s_
yanks125316573yank_s_
zanyish2235903zanyish

Search took 7 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.1731032896.0
2DLD Change Limit1127161586.70316815.8
3Display Results1581580.0463434.8
 (SQL Overall)1786911586.92225814.9
 
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.