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

126 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
distaste93994(None) 
distasted1137951distasted
distastes1039621distastes
bistate9313812bista_te
diastase946592diastas_e
dictate10311662dicta_te
disaster949942dis_aster
discase102912862discas_e
disease83213842diseas_e
dismast10311232dismast_
dismasted1346822dismasted
dismasts1137512dismasts
disrate81418522disra_te
distance11311852distance
distant83519952distant_
distraite10611472distraite
aristate8312123arista_te
cineaste1045743cineaste
costate94019273costa_te
cristate10310593crista_te
dentate8315153denta_te
diabase1037113diabas_e
diamante1186413diamante
diastases1047063diastases
diastasic1244023diastasic
diastem10318043di__astem
diaster82813313di__aster
dicast9315573di_cast_
dicasts1078703di_casts
dictated1239203dicta_ted
dictates11311373dicta_tes
digitate1098683digita_te
diktat11310693dikta_t_
diktats1235623dikta_ts
dilatate947773dilatate
dilate73220693di_la_te
dioptase1145513dioptas_e
diphase1387273diphas_e
disable10516433dis_able
disasters1039143dis_asters
discant103017253discant_
discanted1339333discanted
discants112912023discants
discased122510843discased
discases112014503discases
discrete11410283discrete
diseased103011703diseased
diseases92415813diseases
diseuse83110713diseus_e
disgust937623disgust_
disgusted1246103disgusted
disgusts1045643disgusts
diskette1346753diskette
dismantle1245043dismantle
disparate1249053disparate
dispart101115283dispart_
disparted1338853disparted
disparts11109953disparts
dispose10312753dispos_e
dispute1039083dis_pute
disrated10915573disra_ted
disrates91118143disra_tes
dissave1139413dissa_ve
distaff1467673dista_ff
distaffs1565073distaffs
distain8313783dista_in
distained1139593distained
distains9413603distains
distal73615763dista__l
distally1239553distally
distanced1348573distanced
distances12311653distances
distantly1346393distantly
distasteful1551683distasteful
distasting1248023distasting
distaves12311393distaves
distent84120853distent_
distome10313233dist_ome
distort81120333distort_
distorted1139363distorted
distorter1048403distorter
distorts91112343distorts
distract11313023distract_
distracted1448863distracted
distracts1249283distracts
distrait9414343distrait_
distrust949933distrust_
distrusted1246263distrusted
distrusts1046503distrusts
disunite999293disunite
disuse74012833dis_us_e
disvalue1244433disvalue
ditas65923673di_tas__
estate64719763_esta_te
fissate103010033fissa_te
fistnote1144323fistnote
gestate83614073gesta_te
hastate10313913hasta_te
impaste11258003_impaste
instate71616473insta_te
listable10810303listable
misate81222693mis_a_te
miscast11312403miscast_
miscasts1238343miscasts
misdate101413963misda_te
misease92713043miseas_e
mismate111415353misma_te
misrate91319143misra_te
misstate10711333missta_te
mistake131312613mista_ke
nictate9310223nicta_te
pistache1545893pistache
posthaste1456603posthaste
pretaste10139523pretaste
restate73824873resta_te
retaste72313133_retaste
stacte82113913__stacte
state56237333__sta_te
taste55127233___taste
testate73916233testa_te
tristate8311023trista_te
uintaite8127353uintaite
unstate71916213unsta_te
upstate91610493upsta_te
vistas94513273vistas__
vittate10409723vitta_te

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.376475242.0
2DLD Change Limit1461621268.87316472.7
3Display Results1261260.0632000.0
 (SQL Overall)1786911269.31219189.3
 
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.