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

187 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
vitrics1219855(None) 
vitric112510111vitric_
citric102812312citric_
citrins92614362citrins
metrics11312362metrics
nitric82512062nitric_
nitrids8269632nitrids
nitrils72810702nitrils
vibrios1235802vibrios
vitrains1138282vitrains
vitrify1645002vitrify
vitrine102511362vitrine
vitrines112610912vitrines
vitriol1045692vitriol
vitriols1145052vitriols
agarics10319943agarics
amtracs1198883amtracs
antics84621453ant_ics
astrict9614793astrict
astricts1049463astricts
attics84413283_attics
attrits7310613attrits
aviaries1139783aviaries
aviatrice1443073aviatrice
aviatrices1543163aviatrices
avionics1344953avionics
bionics114310873bionics
biopics13318543biopics
biotics113812173biotics
cities84524853cit_ies
citrals91111673citrals
citrin82615413citri_n
citrine92514023citrine
citrines102513133citrines
citrons92913223citrons
citrous93112993citrous
citrus83610923citr_us
civics13397823ci_vics
clerics1149333clerics
clitics11279973clit_ics
critics112811093crit_ics
darics94314113_darics
diaries83321953diaries
dioptrics1444093dioptrics
dirties83119383dirties
district11413873district
districts1248933districts
ditties83116983ditties
editrices1245323editrices
enterics10312853enterics
entries71523163entries
estrins7315853estrins
ethics11169283_ethics
fabrics1436093fabrics
fibrils1236843fibrils
fibrins1238633fibrins
gothics1336123gothics
iatric8312173iatric_
icterics1247053icterics
ionics84214483_ionics
irids66417773_i_rids
iris45732553_i_ri_s
italics936993_italics
ivories10310713ivories
kitties113213623kitties
latrias71913213latrias
lithias1038823lithias
lithic1139493lithic_
litres65220393litr_es
liturgics1251913liturgics
lyrics11357943_lyrics
matrices12312083matrices
metric10314683metric_
midribs1235513midribs
mimics1289363mi_mics
miotics112710653miotics
mirins83918903mi_rins
mitis75425993mit_i_s
mitres83922073mitr_es
mitring103514143mitring
niteries8318383niteries
nitpick1543783nitpick
nitpicks1643183nitpicks
nitres65519333nitr_es
nitrid72812233nitri_d
nitride82811243nitride
nitrides92910703nitrides
nitrify1335793nitrify
nitril62511533nitri_l
nitrile73011373nitrile
nitriles8269923nitriles
nitrite72314463nitrite
nitrites82313453nitrites
nitros64214123nitr_os
nitrous73512483nitrous
nitwits1035053nitwits
nutrias739813nutrias
optics102810183opt_ics
ostrich1238663ostrich
outrigs82811263outrigs
picnics13297343picnics
picric12309923picric_
pities83828083pit_ies
retries74129073retries
retrims93612373retrims
ricracs1136363ricracs
rubrics1177093rubrics
sferics1236133sferics
silvics1235563silvics
stoics8311113_stoics
strick124813203_strick
stricks134310693_stricks
strict84821043_strict
strips85719653_strips
tetris62816293tetri_s
tics65729633__t_ics
titbits935803titbits
titis56023813tit_i_s
titmice1144663titmice
titres64718933titr_es
titties73617363titties
torics85118353_torics
triacs83913223__triacs
trice75127493__trice
trices84826333__trices
trick115420693__trick
tricks125319013__tricks
tries55742813__tries
trigs65423063__trigs
trims75021473__trims
trios55528093__trios
trips74923363__trips
untrims938613untrims
varias95019903v_arias
varices123313573v_arices
varies94330873v_aries
vatic10316423vat_ic_
veeries102916893veeries
vertices13612283vertices
vestries11314053vestries
viatic11311453viatic_
viatica1245863viatica
vibrio1136223vibri_o
vibrion1245253vibrion
vibrions1345093vibrions
vibrissa1362223vibrissa
vichies15310623vichies
victims1436003victims
victorias1446523victorias
victories1448923victories
victress1344523victress
viers85621953vier__s
vigias104110893vi_gias
vigils104210193vi_gils
vineries112716043vineries
vinic10314973vi_nic_
violins10311453violins
vireos94212453vi_reos
vires84529683vi_r_es
virgas1048883vi_rgas
virgins1137863virgins
virid94116043vi_ri_d
virile9313433vi_rile
virion9310683vi_rion
virions1039873vi_rions
virls85618603vi_r_ls
viroids1137923viroids
virtues10338023virtues
virtus94310143vi_rtus
virus85316843vi_r_us
visits9311423vi_sits
vitals94514303vit_als
vitamins1347083vitamins
vitrain1038943vitrain
vitreous1145843vitreous
vitrifies1547223vitrifies
vittles103211113vittles
vivaries1439263vivaries
vizirs18306713vi_zirs
vortices1369123vortices
votaries11312013votaries
votress1035483votress
withies133913543withies
withins133511693withins
yttrias1044523yttrias
yttric1145433yttric_
zitis145815583zit_i_s

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.563317390.8
2DLD Change Limit1340271876.43620824.6
3Display Results1871870.0632968.3
 (SQL Overall)1786911877.06225303.2
 
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.