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

130 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
diabase103711(None) 
diabases1137221diabases
abase76023482__abase
database1143532database
debase94014472d_ebase
diabasic1345102diabasic
dialyse1135462dialyse
diapause1143892diapause
diastase946602diastase
diphase1387272diphase
disabuse1145552disabuse
discase102912862discase
disease83213842disease
abas68642083__abas_
abased96514993__abased
abaser86414343__abaser
abases85720773__abases
abash106016513__abash
abate76627843__abate
abuse77119563__abuse
anabas8314083anabas_
anabases1038083anabases
anatase738943anatase
babas96325733_babas_
base64847023___base
dabble114515193d_abble
dabs77139403d_ab_s_
dadas75819863d_adas_
dalasi7610623d_alasi
damage10410783d_amage
damask1335843d_amask
databased1342243databased
databases1243913databases
dealate83617843dealate
debased113310583d_ebased
debaser103510413d_ebaser
debases103814133d_ebases
debate94419193d_ebate
decease1049523decease
diabetes1147023diabetes
diabolo1065483diabolo
diagnose1045123diagnose
dialist8517763dialist
diallage1045233diallage
dials64925343dia_ls_
dialysed1344413dialysed
dialyser1243693dialyser
dialyses1236133dialyses
dialyze2044433dialyze
diamante1186423diamante
diamide1138473diamide
diamine10311983diamine
diapason1143623diapason
diapaused1343093diapaused
diapauses1244363diapauses
diaries83321953diaries
diarist8517113diarist
diastases1047073diastases
diazine1738933diazine
diazole1736793diazole
dibasic1246033di_basic
dibble114013843di_bble
dibbles124013333dibbles
dibs76233683di_b_s_
dicambas1553793dicambas_
dicast9315573di_cast
dictate10311663dictate
dieback1646913dieback
diffuse1444373diffuse
dilatate947773dilatate
dilate73220693di_late
diocese1036853diocese
dioptase1145513dioptase
dioxane1565423dioxane
dipsas9359893dipsas_
disable10516433disab_le
disables11410903disables
disabused1344903disabused
disabuses1246203disabuses
disband1138243disband
disbar938513disba_r
disbars10310323disbars
disburse1186443disburse
discased122510853discased
discases112014503discases
diseased103011713diseased
diseases92415813diseases
diseuse83110723diseuse
dismast10311233dismast
dispose10312763dispose
disrate81418523disrate
dissave1139413dissave
distaste939943distaste
disuse74012843di_suse
ditas65923673di_tas_
divagate1344783divagate
divas95418583di_vas_
diverse11429993diverse
divulse1134913divulse
doable93115243doab_le
dogbane1135653dogbane
drabble12238883drabble
drabs85119673drab_s_
dramas95814663dramas_
drayage1234433drayage
dyable12308983dyab_le
firebase1346493firebase
gibbose1244083gibbose
guanase836213guanase
incase83615283_incase
isbas71010403_isbas_
kilobase1453873kilobase
kinase104210653ki_nase
liable81415813liab_le
liaise6310693lia_ise
lianas63713383lianas_
ligase7259913li_gase
limbas105313203limbas_
limbate1139213limbate
lipase8239103li_pase
misease92713043misease
niobate937703niobate
riatas63915093riatas_
ribose839893ri_bose
siamese936503siamese
subbase1139323subbase
surbase939793surbase
tiaras6314553tiaras_
timbale11248803timbale
viable111613773viab_le

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271307.04619021.7
3Display Results1301300.0462826.1
 (SQL Overall)1786911307.49823831.8
 
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.