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

108 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
victory1532698(None) 
victor113210671victor_
victors123311181victors
evictor12346362evictor_
evictors13276852evictors
factory15108352factory
hickory1943902hickory
history1339422history
lictor83610862lictor_
lictors93212602lictors
rectory123512732rectory
vector113212062vector_
vectors123212592vectors
viator93211832viator_
viators102712022viators
viceroy1544932viceroy
victoria1346322victoria
actor71116083_actor_
actorly1246423_actorly
actors81016773_actors
amatory1238643amatory
aviator10229663aviator_
aviators11169903aviators
bicorn103610103bic_orn
bigotry1344523bigotry
bistort91216523bistort
bistoury1343413bistoury
chiccory1742483chiccory
chickory2243363chickory
chicory1735993chic_ory
citatory1347213citatory
cory96941513__c_ory
deviatory1666443deviatory
dicty115116293dict__y
dietary1158663dietary
dilatory12279283dilatory
directory1545883directory
distort81120333distort
doctor938993doctor_
doctorly1443113doctorly
doctors1039993doctors
enactory1346153enactory
factor11911463factor_
factors12912133factors
hector113312653hector_
hectors123513263hectors
ichor1039483_ichor_
ichors11310423_ichors
intort6418923_intort
ivory1137373_i_vory
jittery17346443jittery
lactary1237853lactary
lector83514993lector_
lectors93415773lectors
littery103710493littery
locutory1344273locutory
midstory1445103midstory
minatory1338553minatory
nectary1246223nectary
nitery94412173ni_tery
oratory1039403oratory
picture1158613picture
pillory12247453pillory
piscatory1645273piscatory
rector84019753rector_
rectors93520523rectors
sectary1238273sectary
sector83415933sector_
sectors93116453sectors
signory11427523signory
story86723033__story
succory1444643succory
tictoc1036003ticto_c
tictocs1145903tictocs
tory75840543___tory
vanitory1445733vanitory
vapory14398763v_apory
vectored1435633vectored
vestry1238623vest_ry
viatores11257693viatores
vibratory17235563vibratory
vicar10513863vic_ar_
vicarly1536463vicarly
vicars11712263vic_ars
vicenary1654973vicenary
viceroys1644103viceroys
vichy1639043vic__hy
vicious1239493vicious
victim1337693vict_im
victims1436003victims
victorias1446523victorias
victories1448923victories
victual1246253victual
vigor92612423vi_gor_
vigors102911483vi_gors
vinery124912603vi_nery
visitor1046203visitor_
visitors1146433visitors
visor82512833vi_sor_
visors92912223vi_sors
vivary1536983vi_vary
vizor173010093vi_zor_
vizors18328903vi_zors
vomitory1644413vomitory
votary12248333v_otary
wicopy1634033wic_opy
wintery13399753wintery
wintry12498923wint_ry

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.406440125.6
2DLD Change Limit1340271086.42020876.5
3Display Results1081080.0462347.8
 (SQL Overall)1786911086.87226002.8
 
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.