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

191 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
dextro143612(None) 
debtor938332debtor
destroy1138152destroy
dexter143810892dexter
dextral1577002dextral
dextran1586162dextran
dextrin1587532dextrin
dextrose1645362dextrose
dextrous1646592dextrous
extra1239002_extra
metro74718802me_tro
retro55020952re_tro
sexto124415452sext_o
aero45435343ae__ro
bento75922953bent_o
bestrow1237243bestrow
bettor83612223bettor
bistro8339943bistro
cento76625173cent_o
centra84113883centra
centre84316643centre
cero66329453ce__ro
cuatro838413cuatro
dato56129943d_at_o
datto65416423d_atto
deair65817193deair_
deairs74013783deairs
dear55343603de_ar_
dears65736883de_ars
dearth104212513dearth
deary95826843de_ary
death94822523deat_h
deaths105914443deaths
deathy134210233deathy
debar85517863debar_
debark134210943debark
debars94218043debars
debt77139023debt__
debtors1038533debtors
debts86418373debt_s
decare93919153decare
decern91310953decern
deco76125973de__co
decor84717573decor_
decors94017773decors
decry115514353de_cry
decury1277963decury
deer56739023de_er_
deers64930523de_ers
deet57356583deet__
deets65330243deet_s
defer94619753defer_
defers105116943defers
deform1259613deform
deft85540223deft__
defter104215923defter
deftly1336533deftly
degerm1037893degerm
dehorn10439653dehorn
dehort104618103dehort
deity94316773deit_y
dekare112811563dekare
dekko936393de_kko
delator83015023delator
delt57855273delt__
delta66117773delt_a
deltas74414823deltas
deltic9312503deltic
delts65731793delt_s
demark134211023demark
demo77427553de__mo
demur8311163demur_
demure9311533demure
demurs939773demurs
denar65223293denar_
denari710917353denari
denars74621433denars
denary105316863denary
dendron947653dendron
dent57158413dent__
dental74319173dental
dented84120513dented
dentil74017883dentil
dentin73919573dentin
dents65031803dent_s
denture8311893denture
depart94720563depart
deperm1139363deperm
deport94922393deport
depth114311853dept_h
depths12428573depths
dere56845903de__re
derm76031893de__rm
derry94721373de_rry
descry1256183descry
desert72725493desert
desire7415303desire
desorb95210203desorb
destroys1236693destroys
deter65028043de_ter
deters74724683deters
detox13310953de_tox
deuteron945993deuteron
dewar95817733dewar_
dewars105117073dewars
dewdrop1442813dewdrop
deworm1249523deworm
dex116936883dex___
dexes135224513dex_es
dexie134716893dex_ie
dexies145018343dexies
dexterous1745553dexterous
dextrans1695983dextrans
dextrine1688253dextrine
dextrins16117823dextrins
dextrorse1742353dextrorse
dextroses1745663dextroses
dexy156118553dex__y
diatron839283diatron
dinero75612643dinero
dinitro845563dinitro
ditto65315603d_itto
dobro84412213d_obro
doctor938993doctor
dogtrot947443dogtrot
duro56228023d__uro
editor738663editor
electro92810033electro
entry82414263_entry
euro45325273_e_uro
exert124624143_exert
expo1349183_ex_po
extern1348473_extern
extol1247893_extol
extort13513973_extort
extras13310223_extras
exurb1457703_exurb
fetor81214533fe_tor
foxtrot1746303foxtrot
genro64914033ge_nro
gentoo7311313gentoo
gentry103410443gentry
hector113312653hector
hero74635783he__ro
hetero9312633hetero
hexer155116683hexer_
hexers165612753hexers
intro54915853_intro
keto86223453ke_t_o
lector83514983lector
lento57223393lent_o
maestro945723maestro
mentor8414363mentor
metre74821303me_tre
metros84217803me_tros
nestor63713413nestor
neutron737763neutron
next116631083next__
nitro54914353_nitro
pedro8313153pe_dro
peltry11288653peltry
pesto75723723pest_o
petrol82714063pe_trol
petto76021043pe_tto
recto74520803rect_o
rector84019743rector
repro75315913re_pro
retros63820193re_tros
retry84718083re_try
rezero1578873rezero
sector83415923sector
sentry92912053sentry
sext117338093sext__
sextan13389643sextan
sextet13916873sextet
sexton133610793sexton
sextos134012163sextos
sexts125118383sext_s
tetra53417953te_tra
tetri52716453te_tri
text116033933text__
texts125515043text_s
texture1497083texture
vector113212063vector
velcro1144133velcro
vestry1238623vestry
veto76622993ve_t_o
vexer155513523vexer_
vexers165210403vexers
vext146927763vext__
zero134822463ze__ro

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.1401276364.3
2DLD Change Limit1127161916.40617595.4
3Display Results1911910.0633031.7
 (SQL Overall)1786911916.60927037.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.