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

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

100 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
dextrin158754(None) 
dextran1586161dextran
dextrine1688251dextrine
dextrins16117821dextrins
dentin73919572dent_in
destain8412082destain
detain74617382de_tain
detrain8412252de_train
dextral1577002dextral
dextrans1695982dextrans
dextrines1798312dextrines
dextro1436122dextr_o
estrin6315922_estrin
oestrin7312242oestrin
sextain14257102sextain
bestrid1039973bestrid
centric11312403centric
centring112112953centring
certain92612213certain
citrin82615413_citrin
deairing10311893deairing
dearie73319813de_arie
debris93311493de_bris
decern91310953decer_n
decurion1146623decurion
dehorn10439653dehor_n
deliria868303deliria
deltaic1037023deltaic
deltic9312503delt_ic
deltoid938573deltoid
demerit10314993demerit
denari710917353denari_
denarii8389123denarii
dendron947653dendron
dentil74017883dent_il
dentine83320243dent_ine
denting94422183dent_ing
dentins83419223dent_ins
dentoid9310663dentoid
derris73615273de_rris
desiring10312143desiring
destains9311813destains
destine83719953dest_ine
destiny113111463dest_iny
destrier9311823destrier
destroy1138153destroy
detail74516433de_tail
detains83716093de_tains
detrains9411763de_trains
deuteric1146353deuteric
deuteron946003deuteron
deutzia1743143deutzia
devein1039143de_vein
dexie134716893dex__ie
dexter143810893dext_er
dexterity2044343dexterity
dextrose1645363dextrose
dextrous1646593dextrous
diatron839283diatron
dieldrin1093983dieldrin
distain8313783distain
distrain9412243distrain
doctrine1146733doctrine
dustbin1044543dustbin
editrix1543643editrix
endrin7312403_endrin
entrain7313073_entrain
estrins7315853_estrins
extern1348473_extern
extra1239003_extr_a
extras13310223_extras
gastrin839833gastrin
heparin12410433heparin
lectin82515013lect_in
leptin82512333lept_in
metric10314683me_tric
metring103215293me_tring
neutrino845223neutrino
neutron737763neutron
oestrins8312673oestrins
pectin102615533pect_in
pertain92714963pertain
rectrix1645363rectrix
restrain8311703restrain
restring91518783restring
retain64523283re_tain
retrain7615423re_train
retrim83514883re_trim
seatrain847923seatrain
serin55434443se__rin
sextains15246813sextains
sextan13389643sext_an
sextarii1543183sextarii
sexton133610793sext_on
tectrix1644263tectrix
tetri52716453te_tri_
tetris62816293te_tris
texturing1735223texturing
veratrin1147703veratrin
zeatin15412823zeat_in

Search took 9 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.610292936.1
2DLD Change Limit1340271007.98316789.1
3Display Results1001000.0333030.3
 (SQL Overall)1786911008.62620715.4
 
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.