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 “avant” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

65 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
avant8622466(None) 
alant55742291alant
avast85519361avast
avaunt959601avaunt
savant9416041savant
abaft10318062abaft
adapt81218552adapt
advent102613752advent
agent65829642agent
alan46844082alan_
aland65526412aland
alane56135612alane
alang66023512alang
alans55636172alans
alants67722022alants
ament76036542ament
anent54931842anent
ant37270792__ant
apart74330672apart
arrant6623252arrant
asana5315482asana
askant10412712askant
aslant6317752aslant
aunt46553652a_unt
ava610139322ava__
avail8313882avail
avens86419332avens
avert86029492avert
avian84616052avian_
avians93711562avians
await85524492await
azan136521782azan_
azans146516882azans
brant74742172brant
cant66362032_cant
chant105932692chant
event85924442event
giant65430592giant
grant64840022grant
hant75461592_hant
leant56737782leant
levant9314492levant
meant76537212meant
natant6318732natant
pant66061262_pant
pavan106518472pavan_
pavane114113442pavane
pavans115715592pavans
plant75437112plant
quant143624812quant
rant45864682_rant
riant55833152riant
savants1038652savants
scant79735072scant
slant55238702slant
vacant11415132vacant
van66246332_van_
vane75534692_vane
vang84926042_vang
vans76236732_vans
vast75045122_vast
vat67863452_va_t
vaunt85925312vaunt
vent76049052_vent
want76156172_want

Search took 2 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 Filter178691538000.330541487.9
2DLD Change Limit53800651.57634137.1
3Display Results65650.0164062.5
 (SQL Overall)178691651.92292971.4
 
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.