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 “nipas” 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
nipas7711667(None) 
napas75924351napas
nipa69421631nipa_
nips65830921nip_s
animas84418722animas
bias64738162bi_as
bimas95521742bimas
dips75536912dip_s
dipsas9359892dipsas
ditas65923672ditas
divas95418582divas
dopas85019062dopas
gigas75415582gigas
gips75632922gip_s
hips96433702hip_s
kapas116021732kapas
kinas95626912kinas
kips106430512kip_s
kivas124614732kivas
limas75627632limas
limpas105513082limpas
lipa68425922lipa_
lipase8239102lipase
lips67141442lip_s
liras56021982liras
litas54923772litas
micas96823052micas
milpas101710272milpas
minas75434112minas
mips85534082mip_s
nadas66320812nadas
nairas6312772nairas
nalas55528362nalas
nanas55928632nanas
napa66927262napa_
napes74828462napes
nappas105511612nappas
naps66238582nap_s
neaps75618322neaps
nemas75321572nemas
nibs65028312ni_bs
nicad8312612nicad
nicads938332nicads
nicks114920492nicks
nidal65217102nidal
nides65229132nides
nidus65913572nidus
nighs95013612nighs
nills54926672nills
nils46132452ni_ls
nims66226882ni_ms
nines55937342nines
ninjas1386302ninjas
nip56945982nip__
nippy124911112nippy
nisus56014392nisus
nites55736342nites
nits45741642ni_ts
nival84915772nival
nixes124519622nixes
nizam16310252nizam
nizams1735412nizams
nomas74726412nomas
nonas55126652nonas
nopal75517102nopal
nopals84914022nopals
novas85215362novas
papas94927492papas
pas58775742__pas
pias66542552pi_as
picas94626522picas
pikas114218092pikas
pimas94725102pimas
pinas75434452pinas
pipal95118352pipal
pipals104213642pipals
pipes96030142pipes
pips85837132pip_s
pitas77427672pitas
pupas95219282pupas
rias45540592ri_as
ripes75435772ripes
rips66237432rip_s
sikas94617022sikas
simas75727552simas
sipes76036952sipes
sips65740102sip_s
snipes83917392snipes
snips75818012snip_s
spas67036722_spas
tapas74627712tapas
tepas76521682tepas
tipis76019922tipis
tips66436762tip_s
upas68322382_upas
vigas94817882vigas
vinas85126342vinas
visas84317652visas
vivas114815022vivas
wipes104827082wipes
yipes106017842yipes
yips95226692yip_s
zips155723792zip_s

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.0931921408.6
2DLD Change Limit538001031.69031834.3
3Display Results1031030.0303433.3
 (SQL Overall)1786911031.81398560.9
 
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.