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

126 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
basin7502692(None) 
basic96220521basic
basil75122271basil
basing95427661basing
basins85722761basins
basion84315851basion
basis75429861basis
sasin54626571sasin
abasia8712952abasia
abasing10610672abasing
agin56132712_agin
ain37579092_a_in
akin86328032_akin
amin66042252_amin
ayin76331742_ayin
baaing94916162baaing
bacon95620592bacon
bail65042802ba_il
bairn77515532bairn
bait66556002ba_it
baking135626622baking
baling94829692baling
ban58366842ba__n
bani65334962bani_
banian8315382banian
baning95127832baning
baric96125692baric
baring95135852baring
barn66444642ba_rn
baron78131242baron
bas58681752bas__
basal75722282basal
base64847022bas_e
based85331582based
baser74828922baser
bases75644352bases
bash915240162bas_h
bashing135422582bashing
basics104915122basics
basify1437512basify
basils85717472basils
basinal9310032basinal
basined10310002basined
basinet9318932basinet
basions94213952basions
bask105131422bas_k
basking144718612basking
basks115621762basks
bass66146782bas_s
bassi77019322bassi
basso76017282basso
bassy1012917102bassy
bast66362412bas_t
baste74829982baste
basting104227202basting
bastion9312472bastion
basts75936932basts
batik11614732batik
bating95132252bating
baton75822422baton
baying125222582baying
begin85117352begin
biasing103512452biasing
bin56658642b__in
bison75716982bison
blain75421792blain
blin67228172b_lin
boson76019732boson
bosun75113592bosun
brain76229382brain
brasil8713862brasil
brin67038192b_rin
bruin75818332bruin
burin75626062burin
busing96420592busing
buskin123811492buskin
cabin94820942cabin
cain65643912ca_in
casein83216452casein
casing94829102casing
casini84615862casini
casino84317552casino
easing74926462easing
eosin55220922eosin
fagin9216572fagin
fain75840562fa_in
gain56042162ga_in
gamin84423002gamin
gaskin113610582gaskin
jasmin1538072jasmin
kain85334292ka_in
kamsin1238322kamsin
lain46146282la_in
lapin75222922lapin
lasing74727982lasing
layin84720332layin
lysin84512782lysin
main65345522ma_in
mason74820182mason
matin75132852matin
mavin105722952mavin
nasion63914082nasion
oasis56422552oasis
opsin7613472opsin
pain65647242pa_in
patin76832852patin
pavin105623202pavin
rain46251732ra_in
raisin62716922raisin
rasing74330832rasing
ravin85624652ravin
rawin85521472rawin
resin54131052resin
rosin55325312rosin
sabin74924952sabin
sain45551292sa_in
sarin55239252sarin
sasins64923102sasins
satin55935222satin
savin84625082savin
sin36265892__sin
tain45548072ta_in
takin94921302takin
vain75233002va_in
wain75840202wa_in
zayin174512042zayin

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.296603685.8
2DLD Change Limit538001261.62633087.3
3Display Results1261260.0304200.0
 (SQL Overall)1786911261.95291542.5
 
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.