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

207 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
basis7542986(None) 
bases75644351bases
basic96220521basic
basics104915121basics
basil75122271basil
basils85717471basils
basin75026921basin
basins85722761basins
basks115621761basks
bass66146781bas_s
bassi77019321bassi
basts75936931basts
oasis56422551oasis
abases85720772abases
abasia8712952abasia
abasias9711012abasias
abatis84317932abatis
abris75722602abris
ahis76135382_ahis
ais39083572_a_is
amis66445312_amis
anis45746462_anis
apsis75718292apsis
arsis55722422arsis
asks85721212_asks
aspis74618142_aspis
asps65622092_asps
ass37844062_as_s
axis116127912_axis
baals76122702baals
baas66844672ba_as
baases85218012baases
babas96325732babas
babes95834112babes
babies106123642babies
babus95620332babus
backs135729622backs
bads77048862ba_ds
baffs134718052baffs
bags76645502ba_gs
bahts105617802bahts
bail65042802ba_il
bails75933522bails
bait66556002ba_it
baits76630582baits
bakes117035372bakes
balas76937212balas
balds85524642balds
bales76250082bales
balks114926292balks
balls76236412balls
balms95723922balms
bals66354042ba_ls
balsas86417522balsas
bams87044452ba_ms
bands85233422bands
banes74945582banes
bangs85627772bangs
bani65334952bani_
banish111416042banish
banks115527902banks
banns75321232banns
bans66555132ba_ns
baps86040842ba_ps
barbs95928192barbs
bards87139642bards
bares75457132bares
barfs104826002barfs
baric96125692baric
barks115735812barks
barms96128462barms
barns76335142barns
bars66564092ba_rs
bas58681752ba__s
basal75722282basal
base64847022bas_e
based85331582based
baser74828922baser
basest84720492basest
bash915240162bas_h
bashes115631392bashes
basify1437512basify
basing95427662basing
basion84315852basion
basions94213952basions
bask105131422bas_k
basses85428302basses
bassist9312732bassist
basso76017282basso
bassos85313702bassos
bassy1012917102bassy
bast66362412bas_t
baste74829982baste
bastes85330382bastes
bates75846342bates
baths105922922baths
batik11614732batik
batiks1239372batiks
bats66962332ba_ts
batts76727562batts
bauds85821042bauds
bawds116115492bawds
bawls105719322bawls
bays97143912ba_ys
beasts84519722beasts
beses75830722beses
bests75932612bests
bialis83617162bialis
biases84618432biases
bidis86721142bidis
bis56860652b__is
bises75435622bises
bisks115416802bisks
blasts85116772blasts
bliss75616912bliss
boasts85017922boasts
bosks115218852bosks
boss65938342bos_s
brasil8713862brasil
brasils9410972brasils
brass75428022bras_s
bris65539612b_ris
briss75824272briss
buses75936012buses
busies85525262busies
busks115521372busks
buss65134912bus_s
busts75227692busts
byssi10507992byssi
cadis84428492cadis
casas75327842casas
cases75048382cases
casks115720062casks
cassis84818852cassis
casts77237792casts
casus76419252casus
crasis85020472crasis
dais57040702da_is
dashis104414392dashis
eases56041612eases
easies64126632easies
easts57530322easts
fasts86429682fasts
gadis74825292gadis
gases65633992gases
gasps85415482gasps
gasts66628632gasts
hajis156716272hajis
hasps105114642hasps
kadis105921062kadis
kakis86116842kakis
lapis76223152lapis
laris54737462laris
lases54944762lases
lass47444542las_s
lassi56316852lassi
lassis65216702lassis
lasts57731262lasts
lysis84511462lysis
masas75630412masas
masks115320532masks
mass66044932mas_s
masts77035762masts
mavis105622722mavis
maxis145721562maxis
myasis114010462myasis
nabis76020572nabis
naris55735292naris
nazis145216082nazis
oases55330982oases
oasts56529182oasts
padis86227142padis
paris75145942paris
pases75346502pases
pass65239952pas_s
pastis84924322pastis
pasts75936502pasts
pavis106422732pavis
phasis114614922phasis
psis68120342_psis
qadis155917852qadis
ragis66325602ragis
rais45252622ra_is
rakis95323442rakis
ranis55235832ranis
rases55447212rases
rasps74316662rasps
sadis64930852sadis
sakis95323662sakis
saris54544952saris
sasin54626572sasin
sasins64923102sasins
sass45035622sas_s
satis55633672satis
sis37360542__sis
stasis63116872stasis
tamis76728722tamis
tapis75028862tapis
tasks94917582tasks
tass45640572tas_s
taxis126821972taxis
vases84626262vases
vasts86423772vasts
wadis95223962wadis
wasps106714692wasps
wasts87433672wasts
yagis95416572yagis

Search took 6 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.190940478.9
2DLD Change Limit538002074.11013090.0
3Display Results2072070.1061952.8
 (SQL Overall)1786912074.40640556.3
 
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.