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

149 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
vauntie103663(None) 
auntie64317701_auntie
vawntie1343941vawntie
aunties73920072_aunties
dautie72914702dau_tie
jauntier1535232jauntier
pantie84326472pa_ntie
untie54425492__untie
vaultier1144292vaultier
vaunt85925312vaunt__
vaunted11438862vaunted
vaunter10309602vaunter
vaunting12338752vaunting
vaunts95212622vaunt_s
vaunty12409062vaunt_y
alunite7311633alunite
antae56828293_a_ntae
ante46538903_a_nt_e
anti45536363_a_nti_
antic75728863_a_ntic
antis55033313_a_ntis
antre55224523_a_ntre
augite7312613_augite
aunt46553653_aunt__
auntlier834903_auntlier
auntlike1234983_auntlike
auntly95211063_auntly
aunts55227633_aunt_s
aunty85919813_aunt_y
avaunt959603avaunt__
banties94324763ba_nties
bauxite1635573bauxite
bawtie113812143ba_wtie
bountied1136333bountied
bounties10311403bounties
braunite1047253braunite
cannie83819363ca_nnie
cantic103920543ca_ntic
cantle84522153ca_ntle
carnie84421093carn_ie
cattie85221023ca_ttie
caustic1139753caustic
coontie9311423coontie
counties10316283counties
cutie76925933_cu_tie
daintier937403daintier
dainties9312403dainties
daunt65929083daunt__
daunted93810193daunted
daunter83811753daunter
daunting103310403daunting
daunts75014083daunt_s
dauties83315763dau_ties
dawtie103011093da_wtie
dunite7315013_dunite
faultier1135283faultier
faunae95210373faun_ae
faunlike1534763faunlike
flauntier1243063flauntier
flunkie1434513flunkie
gahnite1135973gahnite
gaunt65430403gaunt__
gaunter82910713gaunter
gauntlet955903gauntlet
gauntly1135333gauntly
gauntries1046043gauntries
gauntry1154113gauntry
gruntle8257053gruntle
gunite7414403_gunite
hankie133915713ha_nkie
hantle94318203ha_ntle
haunt85229133haunt__
haunted11399733haunted
haunter103111153haunter
haunting123510053haunting
haunts95614393haunt_s
haute89521613hau_t_e
hunkie133812383_hunkie
jaunce15367433jaun_ce
jaundice1842013jaundice
jaunt125025273jaunt__
jaunted15418563jaunted
jauntiest1635493jauntiest
jauntily1834173jauntily
jaunting16328633jaunting
jaunts137511883jaunt_s
jaunty16388513jaunt_y
junkie17339603_junkie
kainite1149543kainite
launce8469183laun_ce
mannite9312903mannite
mantic104120903ma_ntic
mantid93820383ma_ntid
mantis83926033ma_ntis
mantle84420923ma_ntle
maundies1137853maundies
muntin82915183_muntin
nannie63713223na_nnie
opuntia9134153opuntia
paintier1048793paintier
panties94230933pa_nties
pantile93918483pa_ntile
pastie85525523pa_stie
pattie84020963pa_ttie
punkie123513613_punkie
punties94520783_punties
puttie84116303_puttie
quantic18279063quantic
quantile1747323quantile
quantize2645963quantize
reunite7312713reunite
runtier73512853_runtier
saltie63422433sa_ltie
santir6315253sa_ntir
saunter72913453saunter
saute55028083sau_t_e
spunkie13215303spunkie
tattie64817513ta_ttie
taunt55532283taunt__
taunted84310963taunted
taunter73111453taunter
taunting93510933taunting
taunts65715663taunt_s
tentie62521183_tentie
unite54828383__unite
untied73720813__untied
unties64326923__unties
until53517743__until
vacate11314553vacat_e
vacuities1447143vacuities
valentine1245893valentine
valuate102512733valuat_e
vane75534693va_n__e
vanitied12138213vanitied
vanities111414493vanities
vanity12311933va_nity
vantage11109893va_ntage
vastier103613203va_stier
vatic10316423va__tic
vault85823763vault__
vaulted11307193vaulted
vaulter10257713vaulter
vaultiest1234833vaultiest
vaulting12227233vaulting
vaults94511673vault_s
vaulty12388443vault_y
vaunters11327753vaunters
vauntful1442473vauntful
yautia937253yau_tia

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.406440125.6
2DLD Change Limit1340271496.70319995.1
3Display Results1491490.0463239.1
 (SQL Overall)1786911497.15524974.3
 
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.