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

140 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
vitrain103894(None) 
vitrains1138281vitrains
citrin82615412citr_in
detrain8412252detrain
distrain9412242distrain
entrain7313072entrain
mistrain10311942mistrain
retrain7615422retrain
strain64919572_strain
train56529112__train
villain1038482villain
virgin1038082vi_rgin
vitamin1237422vitamin
vitric112510112vitr_ic
vitrine102511362vitr_ine
attain6311753_attain
atwain937813_atwain
brain76229383__brain
certain92612213certain
citral81113893citra_l
citrals91111673citrals
citrate92216803citrate
citric102812313citr_ic
citrine92514023citr_ine
citrinin1045783citrinin
citrins92614363citr_ins
citron83112983citr_on
curtain9319793curtain
detain74617383det_ain
detrains9411763detrains
disdain938513disdain
distain8313783distain
distrains10411353distrains
distraint101112903distraint
distrait9414343distrait
drain65222893__drain
engrain838353engrain
entrains8312963entrains
estrin6315923estr_in
fibrin1138533fibr_in
fibroin1246473fibroin
firkin1337823fi_rkin
gittin72910553git_tin
grain65126253__grain
hitman112710223hitma_n
ingrain839523ingrain
ligroin848043ligroin
litai55216363lit_ai_
midbrain1343923midbrain
migraine1157863migraine
mirin75023153mi_r_in
mislain9311243mislain
mistrains11511353mistrains
mitral81314323mitra_l
mitring103514143mitr_ing
murrain937763murrain
nitrate72017023nitrate
nitrating10312683nitrating
nitration9313453nitration
nitric82512063nitr_ic
nitrid72812233nitr_id
nitril62511533nitr_il
obtain839183obt_ain
outgain81010743outgain
outlain71212613outlain
outran63218893outra_n
overtrain1259783overtrain
pertain92714963pertain
pitman102412123pitma_n
pretrain10310923pretrain
quatrain1745833quatrain
rain46251733___rain
refrain10310043refrain
restrain8311703restrain
retain64523283ret_ain
retrains8314533retrains
seatrain847923seatrain
sprain83614863_sprain
stain55727943_st_ain
strains74218153_strains
strait64025893_strait
tain45548073__t_ain
terrain7410853terrain
titan53318173tit_a_n
titian62512663titia_n
titman82711003titma_n
titrant7315193titrant
titrate72215583titrate
titrating10310123titrating
titration9310553titration
traik95418203__traik
trail55126773__trail
trains64725343__trains
trait56940843__trait
twain86313623__twain
vain75233003v___ain
verdin103113023v_erdin
vermin113414523v_ermin
vervain1335563vervain
veteran1039353vetera_n
vibrant12410393vibrant
vibrate122811523vibrate
vibrating1537483vibrating
vibration14138203vibration
vibrato12247393vibrato
vibrio1136223vibr_io
vibrion1245253vibrion
villains1138013villains
villainy1444883villainy
villein1036753villein
violin9311983vi_olin
virago1046643vi_rago
viral86419593vi_ra_l
virgins1137863vi_rgins
virid94116043vi_r_id
virion9310683vi_rion
viroid10411523vi_roid
visaing11279333vi_saing
vita75828533vit_a__
vitae84217633vit_a_e
vital84819673vit_a_l
vitals94514303vit_als
vitamine1347373vitamine
vitamins1347083vitamins
vitellin11105413vitellin
vitiate103412953vitiate
vitiating1338413vitiating
vitiation1239563vitiation
vitrics12198553vitrics
vitrify1645003vitrify
vitrines112610913vitr_ines
vitriol1045693vitriol
vitta85015173vitta__
vittae93911003vitta_e
vittate10409733vittate
vittling1236143vittling
vituline1147093vituline
vivaria1346983vivaria
witan83816503wit_a_n
within123611383wit_hin

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271406.36021073.4
3Display Results1401400.0632222.2
 (SQL Overall)1786911406.84326113.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.