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

270 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
virtue935867(None) 
virtu85314091virtu_
virtues10338021virtues
virtus94310141virtus
cirque1735852cirque
kirtle10309472kirtle
vertu85017612vertu_
vertus94613602vertus
virgule1144282virgule
virile9313432virile
virtual1045912virtual
virtuose1143182virtuose
virus85316842vir_us
vitae84217632vi_tae
vittae93910992vittae
vittle94711752vittle
airbus848343airbus
airt45757783airt__
airted74214503airted
airth85621023airt_h
airthed11328303airthed
airths95414253airths
airtime948063airtime
airts55626343airt_s
aortae65115473aortae
argue64818443_argue
aviate9315203aviat_e
barque17239553barque
battue84311003battue
birdie94013783birdie
bireme10310143bireme
birkie124110133birkie
birle75023633bir_le
birse74517403bir_se
birth105619873birt_h
birthed13228593birthed
births115713603births
bisque17257843bisque
bistre83815023bistre
bite66546993bi_t_e
brute75321783_brute
carte75940423cart_e
cinque1736853cinque
circle1039703circle
circus104310593circus
cire65836373cir__e
cirques1836463cirques
cirrus8349173cirrus
cistus84611343cistus
cite65640343ci_t_e
citrus83610913citrus
dartle73714833dartle
dictum1136863dictum
dilute72911803dilute
dirdum1036033dirdum
dire56644143dir__e
dirge75117073dir_ge
dirt55550383dirt__
dirtied93210853dirtied
dirtier83312093dirtier
dirties83119383dirties
dirts66824463dirt_s
dirty95617803dirt_y
dite55547553di_t_e
evictee1248103evictee
evite85317683evi_t_e
fique1739143fi_que
fire76245593fir__e
firth115819533firt_h
firths125113503firths
fixture1734963fixture
forte86131463fort_e
fortune1068303fortune
giftee103512083giftee
gigue71210673gi_gue
girdle82110463girdle
girlie73711463girlie
girt56646423girt__
girted83912873girted
girth95618843girt_h
girthed12266243girthed
girths105612273girths
girts65423623girt_s
gite55438613gi_t_e
grue55825713_gr_ue
hiatus938223hiatus
hire75538963hir__e
hiree85427803hir_ee
hirple11158973hirple
hirsle9159573hirsle
hirsute1084523hirsute
hurtle93512943hurtle
ictus7249693_ictus
imbue939463_imbue
indue63516673_indue
irade65618153_irade
irate55627983_irate
ire36943173_ir__e
irone55126363_irone
issue559213_issue
istle52214713_istle
ixtle12168013_ixtle
kiltie103210963kiltie
kirtled12287033kirtled
kirtles11309663kirtles
kite85338233ki_t_e
kithe125917453ki_the
kittle104012173kittle
lire47845293lir__e
listee64223063listee
lite47054543li_t_e
lithe84922013li_the
litre55421463li_tre
little63312163little
litu47631563li_tu_
marque172410503marque
minute83414293minute
mirage92313653mirage
mire66748223mir__e
mirth106418893mirt_h
mirths114912993mirths
miscue10412223miscue
mistune9310653mistune
mite66249403mi_t_e
mitre75522423mi_tre
mixture1635413mixture
morgue938113morgue
myrtle1135733myrtle
nite45943583ni_t_e
nitre57519683ni_tre
nurture736643nurture
overdue11138953overdue
overture111511683overture
perdue93912633perdue
picture1158613picture
pintle83818263pintle
pique16410173pi_que
pirate82322883pirate
pirogue1045413pirogue
piroque1844353piroque
piste75824603pist_e
pursue84512253pursue
rictus8379193rictus
risque15227453risque
rite45849453ri_t_e
roue45941743__roue
rue35549263__r_ue
sire46150413sir__e
siree55238813sir_ee
sirree64017333sirree
sirup74014913sir_up
site47052413si_t_e
situp74414063si_tup
situs55019233si_tus
sixte126216583sixt_e
sortie63621983sortie
sprue74717633spr_ue
statue66015323statue
tartufe1064673tartufe
tiptoe838283tiptoe
tirade7311693tirade
tire46143353tir__e
tissue637333tissue
tithe85319703ti_the
title54721073ti_tle
titre54619393ti_tre
tittie63213153tittie
tittle63613323tittle
tittup834203tittup
torque15237673torque
torte55431703tort_e
torture738593torture
trite54730033trit_e
true46725853_tr_ue
turtle63213573turtle
untrue6310773untrue
vague96513113v_ague
value85719093v_alue
varus85921183var_us
varve115716853var_ve
vatu76524333v_atu_
vatus86114643v_atus
vendue10419013vendue
venture10311173venture
venue84918213v_enue
verdure11287773verdure
verge93419833ver_ge
verite94323443verite
verse84723583ver_se
verste94515633verste
versus94211143versus
vert77249373vert__
vertex1637373vertex
verts85724733vert_s
verve115417723ver_ve
vestee94319153vestee
vesture10310373vesture
viable111613773viable
viatic11311453viatic
viator93211833viator
vibe95124493vi__be
vibrate122811513vibrate
vice95732853vi__ce
victim1337683victim
victor113210673victor
victual1246253victual
vide85432753vi__de
vidette1167543vidette
vie65447633vi___e
vigour10256803vigour
vile76139803vi__le
villae95615383villae
villus93611223villus
vine75643683vi__ne
vinous93914173vinous
vintage11128143vintage
vintner1034823vintner
virago1046643virago
viral86419593vir_al
vireo84816453vir_eo
vireos94212453vireos
vires84529683vir_es
virga9310253vir_ga
virgas1048883virgas
virgate1138733virgate
virgin1038083virgin
virgules1244333virgules
virid94116043vir_id
virion9310683virion
virl76224473vir__l
virls85618603vir_ls
viroid10411523viroid
viroses10310533viroses
virtuosa1141943virtuosa
virtuosi1142123virtuosi
virtuoso1141873virtuoso
virtuous1144663virtuous
viruses1039413viruses
visage1049083visage
viscus11428503viscus
vise75632673vi__se
visive1257873visive
vista85416603vist_a
vistaed1138013vistaed
vistas94513273vistas
vita75828523vi_t_a
vital84819673vi_tal
vitric112510113vitric
vitrine102511363vitrine
vitta85015173vi_tta
vittate10409723vittate
vittled11347343vittled
vittles103211113vittles
vivace1436553vivace
vive105426623vi__ve
vogue95613043v_ogue
volte85321303volt_e
volute93912763volute
vortex1635923vortex
vote74728623v_ot_e
vrouw11507343v_rouw
vulture1036763vulture
wintle94014603wintle
wire75839813wir__e
wite75443273wi_t_e
withe115220233wi_the
write85522833writ_e
writhe125310703writhe
yirth116513753yirt_h
yirths12639533yirths

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 Filter1786911127160.1561145455.1
2DLD Change Limit1127162707.05015988.1
3Display Results2702700.0763552.6
 (SQL Overall)1786912707.28224538.7
 
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.