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

125 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
vicarly153646(None) 
viably14199832vi_ably
vicar10513862vicar__
vicars11712262vicar_s
viceroy1544932viceroy
virally1339642virally
vitally1339672vitally
vivary1536982vivar_y
vocably17157152vocably
vocally15188342vocally
amicably1746333amicably
apically1539823apically
aviary12338413avi_ar_y
bialy105119323bi_a_ly
bicarb1238543bicar_b
bicarbs1336013bicarbs
binary11312223binar_y
biparty1445583biparty
biyearly1643393biyearly
carl65144783__carl_
carle74535703__carle
carls77037423__carls
carny105822923__carny
carry105823783__carry
cecally1459393cecally
cicala10310053cica_la
cicale10314503cica_le
cicely1338833cic_ely
civically1946563civically
clearly1236663clearly
curly105321233__curly
dearly104615323_dearly
diary95016973di_ar_y
dicycly1843273dicycly
ducally13257413ducally
early85324123__early
epically15310573epically
fickly18318533fic_kly
finally13310103finally
fiscally1646073fiscally
focally15188553focally
friarly13316213friarly
girly94415293gi__rly
gnarly104610383_gnarly
icily101211683_ic_ily
ickily1535743_ickily
laically1338983laically
lichtly15255523lichtly
licitly12276673licitly
linearly1146783linearly
locally12179723locally
marly106925613__marly
misally121111063misally
miscarry1544473miscarry
miserly12329823miserly
nearly94813733_nearly
nicely1139493nic_ely
pearly116414843_pearly
pical95524373pica_l_
picara10311903picar_a
picaras11311273picaras
picaro10311323picar_o
picaros11310893picaros
piscary1437423piscar_y
recarry1245063recarry
richly1438003ric_hly
rivalry1354033rivalry
scaly104718723_sca_ly
scarey115016983_scarey
scarily12311703_scarily
scarry116311183_scarry
scary105222593_scar_y
sickerly1734023sickerly
sickly153110483sic_kly
sizably2136613sizably
snarly93815003_snarly
tical76021493tica_l_
ticals83214713tica_ls
tidally1137933tidally
uvularly1442693uvularly
vacancy1744443vacancy
vacantly1644063vacantly
vagally1435833vagally
vagary1337333vagar_y
vary105226063v__ar_y
vealy115817773v_ea_ly
venally13119563venally
viable111613773vi_able
vial76731093vi_a_l_
vials85822383vi_a_ls
vicarage1444433vicarage
vicarate1378603vicarate
vicarial1347793vicarial
vicenary1654973vicenar_y
viceroys1644103viceroys
vichy1639043vic__hy
victory15326983victory
vilely1239443vi_lely
vinal85725813vina_l_
vinals94716483vina_ls
vincibly1843583vincibly
vinery124912593viner_y
violably1644923violably
viral86419593vira_l_
virl76224473vi__rl_
virls85618603vi__rls
visard103910123visar_d
visards11328153visards
viscidly1753303viscidly
visibly1535043visibly
visually1465493visually
vital84819673vita_l_
vitals94514303vita_ls
vivaria1346983vivaria
vividly1744233vividly
vixenly2043193vixenly
vizard19458853vizar_d
vizards20377263vizards
vocable14189673vocable
vocal104715643voca_l_
vocals113811583voca_ls
votary12248333votar_y
vulgarly1543163vulgarly
wizardly2452573wizardly
yearly125210273_yearly

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.186960704.3
2DLD Change Limit1340271257.45317983.0
3Display Results1251250.0801562.5
 (SQL Overall)1786911257.71923149.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.