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

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

75 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
vawntie134394(None) 
vauntie1036631vauntie
auntie64317702_auntie
bawtie113812142baw_tie
dawtie103011092daw_tie
pantie84326472pa_ntie
antae56828293_a_ntae
ante46538903_a_nt_e
anti45536363_a_nti_
antic75728863_a_ntic
antis55033313_a_ntis
antre55224523_a_ntre
aunties73920073_aunties
banties94324763ba_nties
bawties124214313baw_ties
cannie83819363ca_nnie
cantic103920543ca_ntic
cantle84522153ca_ntle
carnie84421093carn_ie
cattie85221023ca_ttie
coontie9311423coontie
daintier937403daintier
dainties9312403dainties
dautie72914703da_utie
dawnlike1634673dawnlike
dawties113312703daw_ties
downtime1444753downtime
fawnier13296363fawn_ier
fawnlike1844143fawnlike
gahnite1135973gahnite
gawsie1038463gaw_sie
hankie133915713ha_nkie
hantle94318203ha_ntle
hawkie163810093haw_kie
jauntier1535233jauntier
kainite1149543kainite
mannite9312903mannite
mantic104120903ma_ntic
mantid93820383ma_ntid
mantis83926033ma_ntis
mantle84420923ma_ntle
nannie63713223na_nnie
paintier1048793paintier
panties94230933pa_nties
pantile93918483pa_ntile
pastie85525523pa_stie
pattie84020963pa_ttie
pawnage1335873pawnage
pawnee113115403pawn_ee
saltie63422433sa_ltie
santir6315253sa_ntir
tattie64817513ta_ttie
tawie84819813taw__ie
tawnier10318463tawn_ier
tawnies102812503tawn_ies
tawpie11339143taw_pie
tentie62521183_tentie
townie93312303town_ie
untie54425493__untie
vacate11314553vacat_e
valentine1245893valentine
vane75534693va_n__e
vanitied12138213vanitied
vanities111414493vanities
vanity12311933va_nity
vantage11109893va_ntage
vastier103613203va_stier
vatic10316423va__tic
vaultier1144293vaultier
vaunt85925313vaunt__
vaunted11438863vaunted
vaunter10309603vaunter
vaunting12338753vaunting
vaunts95212623vaunt_s
vaunty12409063vaunt_y

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 Limit134027755.75023309.0
3Display Results75750.0302500.0
 (SQL Overall)178691756.18628886.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.