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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 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
navies9521862(None) 
cavies114525001cavies
davies105020511davies
mavies114923191mavies
naives94914221naives
naves87030381nav_es
navvies1335321navvies
wavies125019841wavies
amies76837682_amies
anvils9219712anvils
aves76142602_av_es
babies106123642babies
bevies114017302bevies
caries85147622caries
caves105639702cav_es
cavie104621592cavie_
cavils114014392cavils
civies114116442civies
davits104012362davits
easies64126632easies
eaves85231992eav_es
envies9314052envies
facies113921592facies
faves115331422fav_es
gabies93820722gabies
gravies11314092gravies
haves116034872hav_es
heavies132713872heavies
ivies84215752_ivies
knaves13439522knav_es
ladies75124882ladies
laves86039152lav_es
lazies154418782lazies
levies93919862levies
mamies104626242mamies
mavie104722562mavie_
mavins115119182mavins
mavis105622722mavi_s
mavises122812992mavises
movies115118452movies
nabes75427092na_bes
nabis76020572nabi_s
naches114622412naches
nacres85614452nacres
nadirs7109002nadirs
naifs87617422na_ifs
nails55730402na_ils
naive85116212naive_
naiver94311352naiver
naivest10309472naivest
names74833362na_mes
nances83618642nances
nancies93516842nancies
nannies73015202nannies
napes74828462na_pes
nappes104515622nappes
nappies114613392nappies
nares55544152na_res
naris55735292nari_s
nasties73520492nasties
nates55238332na_tes
natives10310822natives
navaids1134802navaids
navars92810572navars
nave75732312nav_e_
navel87016572nav_el
navels95712692navels
nazis145216082nazi_s
neves87021872nev_es
newies91014072newies
nixies135313872nixies
novices1238222novices
nudies75217092nudies
oaves84925612oav_es
paries84742512paries
paves104833922pav_es
pavins114919662pavins
pavis106422732pavi_s
pavise114714802pavise
pavises125315492pavises
peavies122213392peavies
rabies85226012rabies
ramies84630462ramies
raves85441972rav_es
ravines104220232ravines
ravins94622562ravins
sanies63031952sanies
saves85838632sav_es
savines104417632savines
savins93923132savins
savvies1337602savvies
shavies134213202shavies
spavies123012942spavies
taxies135817332taxies
varies94330872varies
vies75238622__vies
wadies105121202wadies
waives123714182waives
walies95324522walies
waves115633922wav_es
wavier124613082wavier
waviest134513072waviest
zanies153219672zanies

Search took 5 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 Filter178691825510.216827273.1
2DLD Change Limit825511033.79621746.8
3Display Results1031030.0631634.9
 (SQL Overall)1786911034.07543850.6
 
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.